ALTER DATABASE test SET RECOVERY SIMPLE --将“恢复模式”设置为“简单” GO USE test GO DBCC SHRINKFILE (N'test_log' , 1, TRUNCATEONLY)--收缩日志文件大小到1M GO USE test GO ALTER DATABASE test SET RECOVERY FULL WITH NO_WAIT ----将“恢复模式”设置为“完整” GO ALTER DATABASE test SET RECOVERY FULL GO
转载请说明出处:第六感博客 原文链接: