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.
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.
