SQL Server: Shrink the transaction log
BACKUP LOG database_name WITH TRUNCATE_ONLY
USE database_name
GO
DBCC SHRINKFILE (database_name_log, 1)
GO
BACKUP LOG database_name WITH TRUNCATE_ONLY
USE database_name
GO
DBCC SHRINKFILE (database_name_log, 1)
GO
