-- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE [DB] SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (DB_Log, 100); GO -- Reset the database recovery model. ALTER DATABASE [DB] SET RECOVERY FULL; GO
原文：http://www.cnblogs.com/blossomwei/p/6923009.html