CodePaste Logo
New Snippet New Snippet Recent Snippets Recent Snippets My Snippets My Snippets Web Code Search Snippets Search
Sign inor Register
Language: SQL

Truncate log

236 Views
Copy Code Show/Hide Line Numbers
 GO
DBCC SHRINKFILE(DB_log, 1)
BACKUP LOG DDBWITH TRUNCATE_ONLY
DBCC SHRINKFILE(DB_log, 1)
GO 
by Petter Wigle
  May 31, 2010 @ 12:58am
Tags:

Add a comment


Report Abuse
brought to you by:
West Wind Techologies



If you find this site useful and use it frequently please consider making a donation to support this free service.
Donate