MSSQL 2005: BACKUP LOG changes

TRUNCATE_ONLY is obsolete in 2005:

"BACKUP LOG WITH TRUNCATE_ONLY (NO_LOG) is obsolete. Consider using the SIMPLE recovery model to automatically truncate the transaction log."

Just IMHO: simple recovery model advice looks weird here since the message is a result of manual and not automatic query.

Related Posts:

• MSSQL: The value of Default Constraint
• MSSQL 2000: Row Count Using sysindexes System Table
• MCP Hall of Fame
• MSSQL: Paul McBride on ISNULL vs. COALESCE
• MSSQL: Quest Software to compete Red-Gate
• SQL Server 2005 Product Line published
• Advanced MSSQL 2005: Partitioning, memory management, etc
• More MSSQL
• How to Use XMLHTTP from within T-SQL (sp_oacreate)
• T-SQL Tip: How to Use GETDATE() in User Defined Function