MS-SQL 2000 : Truncate transaction log

Execute the following commands:

DBCC SHRINKFILE(pubs_log, 2)
BACKUP LOG pubs WITH TRUNCATE_ONLY
DBCC SHRINKFILE(pubs_log,2)

This will reduce the transaction log for the “pubs” database to 2MB.

Posted on June 17, 2009 by admin in Misc

blog comments powered by Disqus