Shrinking a SQL Server Log File
Jul.30, 2009 in
Uncategorized
This script just saved my life 
USE <DatabaseName>
GO
DBCC SHRINKFILE(<LogFileName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<LogFileName>, 1)
GO
This script just saved my life
USE <DatabaseName>
GO
DBCC SHRINKFILE(<LogFileName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<LogFileName>, 1)
GO
Leave a Reply