Sunday, February 26, 2012

Event Log: Log Backup Successes

Is there a way to prevent logging the sucessful SQL Server Log Backups to
the application event log? This is not success of the job (we have write to
event log on failure for the job).
We have sql servers with 70 or so different databases on them and back up
the logs every 15 minutes. Do the math. We have to keep our event logs very
large in order to retain the worthwhile information for any length of time.
Thanks!
Michelle
A common request but the answer is no. Even amending the dlevel in
sysmessages won't stop it writing to the event log. We have consolidated
servers with 8 instances and hundreds of databases and I agree it's a
complete pain in the neck :-)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"michelle" <michelle@.nospam.com> wrote in message
news:O1$BIWsCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Is there a way to prevent logging the sucessful SQL Server Log Backups to
> the application event log? This is not success of the job (we have write
> to
> event log on failure for the job).
> We have sql servers with 70 or so different databases on them and back up
> the logs every 15 minutes. Do the math. We have to keep our event logs
> very
> large in order to retain the worthwhile information for any length of
> time.
> Thanks!
> Michelle
>

No comments:

Post a Comment