Home / server / Questions / 292273
Accepted
EkoostikMartin
Asked: 2011-07-21 05:48:24 +0800 CST

SQL 2008 Backups writing to event log

  • 772

I have a maintenace plan settup to take transaction log backups every 15 minutes. Well everytime it does so, it writes a message to the windows event log. How can I disable this? I looked through the maintenance plan configuration and the Agent Job it created and can't see how to change it.

sql-server-2008

1 Answers

  1. Best Answer

    You can disable successful backup event logging by enabling Trace Flag 3226

    To set this persistently add -T 3226 to the Startup Parameters option of the server instance in SQL Server Configuration Manager.

    • Start Config Manager, click on SQL Server Services
    • Right-Click on your server instance (default instance is SQL SERVER (MSSQLSERVER))
    • Click the Advanced tab
    • Add -T 3226 to the string in the Startup Parameters option
    • Restart your server instance
    • 3