Shrink / Truncate Log File On SQL Server 2008
filed in sql on Jun.30, 2010
The common T-SQL script to shrink/truncate log file is using the script below 1 2 3 USE [foo] GO DBCC SHRINKFILE(foo_log, 1) But, if the script run on SQL Server 2008 instance, resulting that the log file still have the same size. In other word you cannot shrink the log file. To solve the issue [...]
