The common T-SQL script to shrink/truncate log file is using the script below USE [foo] GO DBCC SHRINKFILE(foo_log, 1) But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file. To solve… Continue reading
Shrink / Truncate Log File On SQL Server 2008
