兔八哥极品软件园    运行: 2792天 | 文章:587 篇 | 评论:39 条 | 碎语:1条

解决sql servser 2008执行no_log提示 此语句不支持一个或多个选项(no_log)

作者:admin 发布于:2015-1-7 10:42 Wednesday


08不支持no_log清空日志
清空日志
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE 库名称 SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (日志名称, 1); GO
-- Reset the database recovery model.
ALTER DATABASE 库名称 SET RECOVERY FULL; GO


Powered by 兔八哥极品软件 苏ICP备12049267号 sitemap