2013年7月15日
Sqlserver2008日志压缩
摘要： 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 疯狂二十九笔 阅读(200) 评论(0) 推荐(0)