Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

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
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.