Remove backup messages from the error log
The error log records every successful backup, which is of no use. Here is how to turn those messages off.
The SQL Server error log holds important information. Unfortunately it is often drowned in backup messages. By default, every database or log backup operation is written to the error log. That is generally useless, and it takes up a lot of room — especially when you have a strategy of very frequent transaction log backups.
You can turn those writes off with a trace flag, number 3226.
To enable it, use this command:
DBCC TRACEON (3226, -1);
This takes effect immediately, but it is reset when the instance restarts. To make it permanent, add the option to the service startup parameters as well.
To do that:
- On the server, open SQL Server Configuration Manager.
- Go to the SQL Server service and open its properties with a right-click.
- Find the service startup parameters, and add this line:
-T3226