Blog Post

BACKUP LOG with TRUNCATE_ONLY is discontinued

,

As  a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG

 As of SQL Server 2008 , BACKUP LOG with TRUNCATE_ONLY is discontinued.   I still find plenty of SQL Server maintenance scripts using BACKUP LOG with TRUNCATE_ONLY.

 In SQL SQL Server 2008 – an error message will appear - TRUNCATE_ONLY is not a recognized BACKUP option.

 In SQL Server 2005 – executing BACKUP LOG with TRUNCATE_ONLY will  cause this message to appear in the SQL Server Error Logs.

 “BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.”

If the database is in Simple Recovery , the logs are truncated automatically. If the database is in Full Recovery , and the log backup chain must be deleted – switch to Simple Recovery

Read 2,078 times
(20 in last 30 days)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating