Friday, May 14, 2010

SQL Server Transaction Log too big...

USE MyData
GO
DBCC SHRINKFILE(MyData_log, 1)
BACKUP LOG MyData WITH TRUNCATE_ONLY
DBCC SHRINKFILE(MyData_log, 1)
GO
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)