SQL Server Skip Successful Backup Messages in SQL Error log and Windows Log

I was recently given a new SQL box to administer which had around 50 databases. All the Tlog Backup were scheduled to run every 15 minutes which was cluttering the SQL Server logs as well as Windows Event Logs because of all the successful Backup messages. Luckily, in SQL Server, we can turn off these Successful Backup Messages if we want !!

This can be done by Trace Flag – 3226.

For more details, you can refer the blog by Kevin Farlee, the Storage Engine PM.