Truncate Transaction Log

Truncate SQL Server 2005 Transaction Log

Truncate SQL Server Log File - 2005 or 2008

Here are two tricks to truncate log file for a database in SQL Server 2005. The work environment is MS SQL Server Management Studio. MS SQL Server 2008 appears to behave similarly.

Select option below for step by step instructions...

SQL Server 2005 or 2008 Truncate Transaction Log Options

I.  Shrink the log file size at the right time

Alternate Solution if Above Fails

II. Eliminate the log file completely