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
