This blog is moved to
http://amalhashim.wordpress.com

Friday, March 13, 2009

To Shrink SqlServer log file.

USE DatabaseName
GO
DBCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY

Posted by A.m.a.L Hashim at 4:47 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)