Howto shrink / truncate SQL transaction log file in SQL Server 2005

USE <databasename>

GO

DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)

BACKUP LOG <databasename> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)

GO

Leave a Reply

Your email address will not be published. Required fields are marked *