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