SQL Server Truncate Logfile

You may truncate your SQLServer logfile using the following instructions:

1. Open Microsoft SQL Server Management Studio

2. Open SQL Query Analyzer. Replace the parameters with the database to be truncated and run the script:

USE BACKUP log with TRUNCATE_ONLY EXEC SP_HELPFILE

3. Using the log file from the results above, place the name of the log file into the parameter and run the script.

go   DBCC SHRINKFILE

= Links for SQL Server Truncate logfile = http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/