How do I shrink the transaction log on MS SQL 2000 databases? - Stack Overflow

How do I shrink the transaction log on MS SQL 2000 databases? - Stack Overflow

瀏覽:821
日期:2026-04-22
Backup transaction log and shrink it. If the DB is being backed up regularly and truncated on checkpoint, it shouldn't grow out of control, however, if you are doing a large number (size) of transactions between those intervals, it will grow until the nex...看更多