Truncate Logs for SQL Server 2008

最新推荐文章于 2024-11-12 14:54:23 发布

envykok

最新推荐文章于 2024-11-12 14:54:23 发布

阅读量164

点赞数

分类专栏： SQL 日志与备份还原文章标签： sql server database command file sql

SQL 日志与备份还原专栏收录该内容

31 篇文章 0 订阅

订阅专栏

Truncate Logs for SQL Server 2008

I had previously posted how to Truncate Logs for SQL Server 2005. Unfortunately, this method does not work in SQL Server 2008. The reason is because the “WITH TRUNCATE_ONLY” command is no longer in SQL 2008. Assuming you run in full recovery mode, the new script to do this is:

USE [{DatabaseName}]
GO
ALTER DATABASE [{DatabaseName}] SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE({TransactionLogLogicalName})
GO
ALTER DATABASE [{DatabaseName}] SET RECOVERY FULL
GO

Simply setting the database mode into simple recovery mode performs the actual truncation but the file is not shrunk by that. DBCC SHRINKFILE will take care of that second step. And don’t forget to put it back into full recovery mode at the end!!