Posts tagged "full"

Shrink / Truncate Log File On SQL Server 2008

The common T-SQL script to shrink/truncate log file is using the script below

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 the issue here’s a work… Continue reading