Thursday, March 3, 2011

Shrink SQL Server Logfile

EXEC sp_dboption 'MCB', 'trunc. log on chkpt.', 'TRUE';
CHECKPOINT;
DBCC SHRINKFILE (MCB_Log, 200);
Posted by Richard A. Hunt at 6:27 PM
Labels: ,

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)