解决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