Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stop logging backups in the System Event Log

Status
Not open for further replies.

northrd

Programmer
May 18, 2003
74
AU
Wow. I just found this trick, courtesy of Greg Robidoux ( 3/18/2008 on mssqltips).

If you do backups often you may see that the System event log will fill quite quickly with Backup notifications. To STOP this logging you can try this

DBCC TRACEON (3226,-1)

And to turn it back on

DBCC TRACEOFF (3226,-1)

Now, this works with MS SQL 200, 2005 & 2008.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top