SQL2008 's shrink log due to SQL2008 's optimization of file and log management, the following statements can be run in SQL2005 but have been canceled in SQL2008: (SQL2005) Backuplog dnname withno_logGoDump TransactionDnname withno_logGo UseDnnameDBCCShrinkfile (2)Go--------------------------------------------------------------(SQL2008): In the SQL2008 to clear the log must be in simple mode, and so on after the removal of the action is complete and then back to full mode. Scenario One: Full command mode Use[Master] GO ALTER DATABASEDnnameSETRECOVERY Simple withno_waitGO ALTER DATABASEDnnameSETRECOVERY Simple--Simple Mode GO UseDnnameGO DBCCShrinkfile (N'Dnname_log', One, Truncateonly)GO Use[Master] GO ALTER DATABASEDnnameSETRECOVERY fullwith no_waitGO ALTER DATABASEDnnameSETRECOVERY Full --revert to Full mode GO
SQL Server 2008 Shrink log Empty Delete large log file