| Author |
Stop Sqlserver logging to application event viewer
|
|
| Paul Rohde 2002-11-20, 3:23 pm |
| I would like to know if I can get Sql Server 2000 to stop
logging successful completed transaction and complete
backups to the Event Viewer application log. These
informational messages are filling up the application log
as I do tranaction log backups every 15 minutes.
I only want the failed or problem backups to be logged.
| |
| Keith Kratochvil 2002-11-20, 3:23 pm |
| Check the notifications tab on the jobs that you have defined.
--
Keith, SQL Server MVP
"Paul Rohde" <paul.rohde@wcrb.org> wrote in message
news:c2bd01c290d7$4ab8f940$8df
82ecf@TK2MSFTNGXA02...
> I would like to know if I can get Sql Server 2000 to stop
> logging successful completed transaction and complete
> backups to the Event Viewer application log. These
> informational messages are filling up the application log
> as I do tranaction log backups every 15 minutes.
>
> I only want the failed or problem backups to be logged.
>
>
| |
| Paul Rohde 2002-11-20, 3:23 pm |
| Keith, these backups are scheduled via a maintenance plan, I don't see a
notification tab in the maintenance plan window. Could you please
elaborate, I am not much of a Sql Server guru.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Keith Kratochvil 2002-11-20, 4:23 pm |
| I don't use maintenance plans. I did set one up and I could not see where
to modify the logging to the application log.
Perhaps you could try creating your own scheduled job (under the SQL Server
Agent node -- Jobs). When you are certain that the job works as expected
you can delete the database maintenance plan.
--
Keith, SQL Server MVP
"Paul Rohde" <paul.rohde@wcrb.org> wrote in message
news:OTL9OqNkCHA.2596@tkmsftngp10...
> Keith, these backups are scheduled via a maintenance plan, I don't see a
> notification tab in the maintenance plan window. Could you please
> elaborate, I am not much of a Sql Server guru.
>
> Thanks
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| Paul,
I haven't found a way (yet) to stop SQL Server writing to eventlog each time it does a backup. I
don't think you can do that...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Paul Rohde" <paul.rohde@wcrb.org> wrote in message
news:c2bd01c290d7$4ab8f940$8df
82ecf@TK2MSFTNGXA02...
> I would like to know if I can get Sql Server 2000 to stop
> logging successful completed transaction and complete
> backups to the Event Viewer application log. These
> informational messages are filling up the application log
> as I do tranaction log backups every 15 minutes.
>
> I only want the failed or problem backups to be logged.
>
>
|
|
|
|