Monday, May 21, 2012
MargonOrangePurpleSkyblueYellow Small width layoutMedium width layoutMaximum width layoutMaximum textMedium textSmall text
Info Register
Stuff To Remember Minimize

Truncate an SQL Log File

Nov 6

Written by: host
11/6/2009 8:05 PM

 

dbcc shrinkfile(dbname_log,1)

backup log dbname with truncate_only

dbcc shrinkfile(dbname_log,1)

Trackback Print
Location: Blogs Gavin's Stuff To Remember
Tags:
Stuff To Remember Minimize
You must be logged in and have permission to create or edit a blog.
Print  
Stuff To Remember Minimize
Print  
Stuff To Remember Minimize
Print  
Stuff To Remember Minimize
Print  
Copyright 2008 by Glowe-ware Software
Terms Of UsePrivacy Statement
Home::Links::GSS Register::News::Info