Friday, March 13, 2009

To Shrink SqlServer log file.

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

No comments:

Post a Comment