SQL Server 2008 R2 下如何清理数据库日志文件
废话不多说，直接上代码，清理后日志文件为1M
USE [master]GOALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE [数据库名] SET RECOVERY SIMPLEGOUSE [数据库名]GODBCC SHRINKFILE (N'[数据库日志文件名称]' , 0,TRUNCATEONLY)GOUSE [master]GOALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE [数据库名] SET RECOVERY FULLGO--查询指定数据库的日志文件名称USE [数据库名] GOSELECT name FROM SYS.database_files WHERE type_desc='LOG'08R2通过，其他版本未测试
