Truncate 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

NorthWest Data Solutions has experienced Oracle developers ready to serve you

NorthWest Data Solutions has experienced Microsoft SQL Server developers ready to serve you

NorthWest Data Solutions has experienced mySQL developers ready to serve you

And more...


NorthWest Data Solutions is based in Anchorage, Alaska. Call (907) 227-1676