摘要: 截断日志1.alterdatabasedbnamesetrecoverysimple2.收缩日志文件脚本:USE [master]GOALTER DATABASE NS_LCHL SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE NS_LCHL SET RECOVERY SIMPLE --简单模式GOUSE NS_LCHLGO--收缩日志文件的初始大小DBCC SHRINKFILE (N'TopsERP_BIZ_log' , 11, TRUNCATEONLY)GO /*'这里的DNName_Log 如果不知道在sys.da 阅读全文
posted @ 2013-08-29 11:15 子萧 阅读(361) 评论(0) 推荐(0) 编辑