Calendar

November 2007
S M T W T F S
« Oct   Jan »
 123
45678910
11121314151617
18192021222324
252627282930  

Categories

Shrinking SQL 2000 Transaction log file

I have recently run into an issue on my test servers with my SQL 2000 log files being full. This has caused many of my jobs to fail unexpectedly. In my research, I have found the following MS Knowledge Base article addressing how to shrink the transaction log files. It also includes instructions on how to backup the log file before the shrink, in order to mitigate losing any data.

Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE