SQL2008 清除日志

Posted on 2013-09-11 13:08 杨彬Allen 阅读(285) 评论(0) 编辑收藏举报

USE [master]GOALTER DATABASE BizTest SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE BizTest SET RECOVERY SIMPLE --简单模式GOUSE [BizTest]GODBCC SHRINKFILE (N'MetaTestTarget_log' , 11, TRUNCATEONLY) GOUSE [master]GOALTER DATABASE [BizTest] SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE [BizTest