Advanced Search

Return to Snippet

Revision: 10148
at December 10, 2008 02:55 by robe
Initial Code 
backup log somedb with truncate_only
use somedb
sp_helpfile  --this provides a list of files used by current db
dbcc shrinkfile('somedb_log', 3)
Initial URL 









Initial Description














Initial Title





SQL Server truncate log and shrink file









Initial Tags














Initial Language





SQL