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

And more...

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

Alaska Web Services

• Web Designs in Alaska
• Custom Web Development
• Our Web Design Process
• Alaska Web Portfolio
• Internet Marketing (SEO)
• E-Commerce