truncate sql log

Steve Stonebraker posted this in MSSQL, Software, Windows on September 23rd, 2010

First off, You CANNOT REVERT this command, so be sure you want to truncate the log!
THE QUERY
Instructions: Just replace with your DB

BACKUP LOG  WITH TRUNCATE_ONLY 
DBCC SHRINKDATABASE( '', TRUNCATEONLY)

Brakertech