SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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


Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...