Shrink database log file Mike25/02/2014 -- Shrink the Transaction Log USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO