There’s a well known problem that every time a backup operation succeeds a message is written into the error log and Windows event log. If you’re taking very frequent log backups (say every 5 minutes) of multiple databases, that’s a significant amount of clutter in the logs. Well – now there’s a fix!


Kevin Farlee, the Storage Engine PM responsible for (among many other things) BACKUP and RESTORE has just blogged about a trace flag - 3226 – that’s been in the product since SQL Server 2000 that will suppress the success messages. He’s planning to document this (and other) trace flags in this area starting in SQL Server 2008. Excellent!