摘要: --SQL2008清空日志文件(数据库和日志文件名一定要是原始文件名!!!)USE [master]GOALTER DATABASE DBData SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DBData SET RECOVERY SIMPLE --简单模式GOUSE DBDataGODBCC SHRINKFILE (N'DBData_Log' , 11, TRUNCATEONLY)GOUSE [master]GOALTER DATABASE DBData SET RECOVERY FULL WITH NO_WAITGOAL 阅读全文
posted @ 2014-02-20 14:30 御不凡 阅读(183) 评论(0) 推荐(0) 编辑