Sunday, May 9, 2010

Shrinking log Database SQL Server 2005

USE DBNAME
GO
DBCC SHRINKFILE(DBNAME_log, 1)
BACKUP LOG DBNAME WITH TRUNCATE_ONLY
DBCC SHRINKFILE(DBNAME_log, 1)
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)