How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

How do I prevent SQL Server 2000 from posting successful backup
completion messages to the Windows 2000 Application Event Log?
I have scheduled jobs which backup my transaction logs on 50+ databases
and it always writes to the Windows 2000 application event log upon
completion.
Due to the frequency of the jobs it only takes a day for the
Application Log to fill up, which is causing other jobs to get hung up
when trying to write to it. On my Windows 2000 server, I have the
application log event viewer setting correctly set as:
"When maximum log size is reached - Overwrite events as needed" but for
some reason this setting no longer applies like it did for the past
three years. SQLServerAgent and MSSQLSERVER both run under a local
Admin account, without a domain.
When I researched how prevent SQL Server from logging this type of
message, I found that I can use sp_update_alert to disable this
message, but I cannot find
the message_id to correctly disable this message. In sysmessages, the
message I am trying to suppress is
error:18265 severity:10 dlevel:128 description:Log backed up: Database:
%1, creation date(time): %2(%3), first LSN: %4, last LSN: %5, number of
dump devices: %7!d!, device information: (%8). mslangid:1033

I tried calling sp_update_alert as follows:

exec sp_update_alert @name = 'Log backed up: Database: %1, creation
date(time): %2(%3), first LSN: %4, last LSN: %5, number of dump
devices: %7!d!, device information: (%8).', @enabled = 0

but got the error message:

Server: Msg 14262, Level 16, State 1, Procedure sp_update_alert, Line
105
The specified @name ('Log backed up: Database: %1, creation date(time):
%2(%3), first LSN: %4, last LSN: %5, number of dump devices: %7!d!,
device inf') does not exist.

Looks like it can only handle 128 characters.

How can I disable this message from being logged in the Application
Log? Or alternatively, how can I get the event viewer to behave as
expected and
"Overwrite events as needed"?

Thanks,

Mike Orlando

.

Relevant Pages

  • Using an intranet webserver...would setting affinity mask help?
    ... We have a dual 1.3GHz processor system running Windows ... 2000 Advanced Server with SQL Server 2000 Standard Edition ... second processor and you can even set affinity for it. ... These jobs, I believe, are ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)