Truncate SQL Server transaction log

by Miro 30. April 2009 22:28

Sometimes you can't shrink the transaction log using the SSMS utility. Try truncating the log first:

BACKUP LOG [DatabaseName] WITH TRUNCATE_ONLY
or, if you want to back up the log:
BACKUP LOG [DatabaseName] TO [NewFileName]

then run

DBCC SHRINKFILE([LogFileName], [MinRequiredLogFileSize])

Tags:

SQL Server

Powered by BlogEngine.NET
Contents copyright 2008 Mirocle Pty. Ltd. All Rights Reserved.