摘要:
SQL2008数据库的日志清理 .SQL如下:数据库名称 =DBNameUSE [master]GOALTER DATABASE DBName SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DBName SET RECOVERY SIMPLE --简单模式GOUSE DBNameGODBCC SHRINKFILE (N'DBName_Log' , 11, TRUNCATEONLY)GOUSE [master]GOALTER DATABASE DBName SET RECOVERY FULL WITH NO_WAITGOALTE 阅读全文