Search This Blog

Friday, February 20, 2009

Shrink SqlServer 2000 transaction log

DBCC SHRINKFILE(xxxx_Log, 2)

xxxx_Log is the name of the transaction file