Shrinking SQL 2000 Transaction log file

By xerocube | November 27, 2007

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

Topics: Tech | 1 Comment »

One Response to “Shrinking SQL 2000 Transaction log file”

S.J.PATE Says:
November 28th, 2007 at 4:43 pm

Truly amazing, thanks so much

Comments

Archives

Blogroll

RockinMedia