废话不多说，直接上代码，清理后日志文件为1M
- USE [master]
- GO
- ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT
- GO
- ALTER DATABASE [数据库名] SET RECOVERY SIMPLE
- GO
- USE [数据库名]
- GO
- DBCC SHRINKFILE (N‘[数据库日志文件名称]‘ , 0,TRUNCATEONLY)
- GO
- USE [master]
- GO
- ALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAIT
- GO
- ALTER DATABASE [数据库名] SET RECOVERY FULL
- GO
-
- USE [数据库名]
- GO
- SELECT name FROM SYS.database_files WHERE type_desc=‘LOG‘
08R2通过，其他版本未测试
SQL Server 2008 R2 下如何清理数据库日志文件
原文：http://www.cnblogs.com/rrxc/p/4554494.html
