truncate sql log

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)

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>