摘要:
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 阅读全文