摘要: SqlServer2008日志压缩语句如下:USE [master]GOALTER DATABASE DBName SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DBName SET RECOVERY SIMPLE --简单模式GOUSE DBName GODBCC SHRINKFILE (N'DBName_log' , 11, TRUNCATEONLY)GOUSE [master]GOALTER DATABASE DBName SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DB 阅读全文
posted @ 2013-07-15 11:09 疯狂二十九笔 阅读(195) 评论(0) 推荐(0) 编辑