Shrinking a SQL Server Log File
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