Archive for October, 2012
Shrink Log FIle SQL Server 2000
October 11, 2012
Leave a comment
EXEC sp_dboption ‘vcr’, ‘trunc. log on chkpt.’, ‘TRUE’
go
use vcr
checkpoint
go
DBCC SHRINKDATABASE (vcr, 10)
Categories: Uncategorized
SQL Server