适用于SQL Server 2005的方法
Backup Log DNName WITH no_log GO DUMP TRANSACTION DNName WITH no_log GO USE DNName DBCC SHRINKFILE (2) GO
适用于SQL Server 2008的方法
USE [master] GO ALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE DNName SET RECOVERY SIMPLE --简单模式 GO USE DNName GO DBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY) GO USE [master] GO ALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE DNName SET RECOVERY FULL --还原为完全模式 GO