Stop SQL Backups to write to the SQl and Event Log

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Stop SQL Backups to write to the SQl and Event Log

Author

Topic

carloarango
Starting Member

15 Posts

Posted - 2010-04-14 : 11:04:28

I have Backups setup thru Maintenance plans; how can I prevent SQL to write to the SQL and event logs every time it succeeds; I have about 200 DBs and keeps filling up the Application Event Log and besides it is making harder to read the SQL logs.

Thanks.

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-04-14 : 16:49:21

Enable trace flag 3226 through startup parameter