473,835 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Sep 12 '05 #1
9 7406
Mike (mj*******@camp systems.com) writes:
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


Look in msdb..sysalerts . You should find the message there. If you don't,
I suppose that sp_update_alert is not your guy after all.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Sep 12 '05 #2
I agree, sp_update_alert is not the answer. I actually checked the
sysalerts table and only found 10 rows in this table. None matched the
message which I'm trying to suppress. Since I'm looking for a
message_id, I also tried calling sp_altermessage 17055, 'WITH_LOG',
'false' using the event ID 17055 found in the Windows Event Viewer and
also tried with 18265, which is the first part of the event
description, but no luck. Any other suggestions? Thanks.

Sep 14 '05 #3
Mike (mj*******@camp systems.com) writes:
I agree, sp_update_alert is not the answer. I actually checked the
sysalerts table and only found 10 rows in this table. None matched the
message which I'm trying to suppress. Since I'm looking for a
message_id, I also tried calling sp_altermessage 17055, 'WITH_LOG',
'false' using the event ID 17055 found in the Windows Event Viewer and
also tried with 18265, which is the first part of the event
description, but no luck. Any other suggestions? Thanks.


Since I don't know this stuff myself very well, I asked in our internal MVP
forum, and Jasper Smith who I trust to know this very well told me that
there is no way to prevent the logging to event log.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Sep 14 '05 #4
GP
Erland Sommarskog wrote:
Mike (mj*******@camp systems.com) writes:
I agree, sp_update_alert is not the answer. I actually checked the
sysalerts table and only found 10 rows in this table. None matched the
message which I'm trying to suppress. Since I'm looking for a
message_id, I also tried calling sp_altermessage 17055, 'WITH_LOG',
'false' using the event ID 17055 found in the Windows Event Viewer and
also tried with 18265, which is the first part of the event
description , but no luck. Any other suggestions? Thanks.

Since I don't know this stuff myself very well, I asked in our internal MVP
forum, and Jasper Smith who I trust to know this very well told me that
there is no way to prevent the logging to event log.

This might be an obvious thing to look at, but have you tried this..?

1. Open the properties of the job.
2. Go to the Notifications tab.
3. Make sure that the "Write to the Windows Application Event Log"
option is un-checked.

Sep 14 '05 #5
[Posted and mailed]

"Mike" <mj*******@camp systems.com> writes:
I agree, sp_update_alert is not the answer. I actually checked the
sysalerts table and only found 10 rows in this table. None matched the
message which I'm trying to suppress. Since I'm looking for a
message_id, I also tried calling sp_altermessage 17055, 'WITH_LOG',
'false' using the event ID 17055 found in the Windows Event Viewer and
also tried with 18265, which is the first part of the event
description, but no luck. Any other suggestions? Thanks.


I spoke too soon when I said that it is not possible.

You can use trace flag 3226 to suppress these messages.

There is also a related trace flag 3001 that suppresses logging
to msdb.backuphist ory.

These flags are undocumented with all that means. On the other hand,
I got them from a Microsoft engineer who said it was OK to share them.

--
Erland Sommarskog, Stockholm, es****@sommarsk og.se

Sep 19 '05 #6
Thanks GP, but when I uncheck the "Write to the Windows Application
Event Log"
option the job still writes to the Application Event Log. I noticed
some strange behavior when unchecking this option. When it is checked
the drop down that's associated with it is showing "When the job fails"
so before unchecking it I changed the drop down to "When the job
succeeds" and then unchecked the box. After applying the changes and
running the job, the Application Event Log still gets written to, and
when I go back to the job I just changed, I see the disabled drop down
showing "When the job fails" again. I want to see the messages getting
written if the job fails, but only suppress the informational messages
upon success, but either way this method fails to suppress the
successful informational messages. FYI, I have never seen the
Transaction Log Backup job fail.

Sep 20 '05 #7
Thanks Erland but I'm still not achieving my objective. Neither DBCC
TRACEOFF (3226) nor DBCC TRACEOFF (3001) stops the logging. I tried it
on the Master and the msdb databases and nothing changed. Should this
command be run against a different database? Mike

Sep 20 '05 #8
Mike (mj*******@camp systems.com) writes:
Thanks Erland but I'm still not achieving my objective. Neither DBCC
TRACEOFF (3226) nor DBCC TRACEOFF (3001) stops the logging. I tried it
on the Master and the msdb databases and nothing changed. Should this
command be run against a different database? Mike


Of course not. TRACEOFF turns off the trace flag! :-)

I didn't specify how to should activate the flag, because I was not
given any details on that. The simplest might be to add to the command
line (you can do this from Enterprise Manager), but it requires a server
restart).

I believe that DBCC TRACEON from a query window affects that process only,
nut adding -1 affects the server level. But I am very foggy on that point.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Sep 20 '05 #9
Just wanted to add a usage note here. I was pestered by the same
situation (event log overload from transaction replication on 40+ DBs).

I was able to suppress the backup / restore events in the Application
Event Log, resulting from SQL Log Shipping with these steps:

1) Go to the SQL Server Properties via Enterprise Manager (i.e. right
click the server and go to properties)
2) General Tab
3) Startup Parameters
4) Add new startup parameter--> /T3226
5) Apply / close dialog
6) Restart SQL Server instance

I am still able to view my backup / copy / restore history from the Log
Shipping Monitor or from the histories of each individual SQL Agent
job. That is much cleaner for my purposes.

Good luck -
Dave
Erland Sommarskog wrote:
Mike (mj*******@camp systems.com) writes:
Thanks Erland but I'm still not achieving my objective. Neither DBCC
TRACEOFF (3226) nor DBCC TRACEOFF (3001) stops the logging. I tried it
on the Master and the msdb databases and nothing changed. Should this
command be run against a different database? Mike


Of course not. TRACEOFF turns off the trace flag! :-)

I didn't specify how to should activate the flag, because I was not
given any details on that. The simplest might be to add to the command
line (you can do this from Enterprise Manager), but it requires a server
restart).

I believe that DBCC TRACEON from a query window affects that process only,
nut adding -1 affects the server level. But I am very foggy on that point.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp


Oct 7 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
1517
by: henryavl | last post by:
Hello All, I recently had to reinstall windows 2000 professional due to a harddrive crash, I downloaded all the newest updates, now I find that session variables are not being kept from page to page as it had with older software. If any else had this problem with IIs 5.0, frontpage 2002 server extentions I would appreciate a tip. What I have found out so far is that the session variables used with asp 3.0 are going away in favor of...
5
2126
by: Michael Adkins | last post by:
I have a new ASP project that I need to desperately test on my Windows 2000 machine before posing to my Hosting Company. I am having problems getting the ASP pages to run from LocalHost. I will attempt to give as much information of what I have done to try to correct this without success. First my setup. Windows 2000 Professional with Service Pack 2 installed. IIS is installed. I have turned off the firewall just in case that was a...
0
2451
by: | last post by:
Hi there movers & shakers, The example below demonstrates a behaviour that is anoying the tits off of me! It doesn't happen whilst debugging from the IDE only when you run the compiled exe from windows explorer. I'm basically trying to display a splash screen in a seperate thread which has it's own message pump. When the call to Application.ExitThread() closes down the splash screen's thread, form and message pump, the main form (and...
9
2299
by: Daniel Walzenbach | last post by:
Hi I am faced with the following problem: I have a page (let’s call this page page1.aspx) containing some TextBoxes and a hyperlink which opens another page (let’s call this page page2.aspx) as a popup using either window.open or window.showModalDialog. Since I want to warn the users of my application when they try to close page1.aspx and have changed the values in the meantime I thought about using the “onbeforeunload” event of the...
11
2428
by: Patrick | last post by:
I have an ASP.NET application that connects to a SQL Server database. The SQL Server resides on a seperate development server from the IIS5.1 on Windows XP SP2 on development PCs which host the ASP.NET application. I would like to use Integrated Windows Authentication like Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBName;Data Source=DevServer1 My problems!
0
1270
by: Roman Troshkov | last post by:
Hello, I Hope to see any opinions on this problem: After installing Net framework 2 on one of our Win2003 Web server I have experiencing trouble accessing MS SQL 2000 database. Configuration is: ASP.NET application is running on WEB server with application pool security account set to “Network Service”. This application accessing MS SQL 2000 server databases located on another server.
8
2038
by: Mark Rowland | last post by:
Please bear with me, as I am a newbie in the world of databases and DB2. We are trying to migrate an application that binds to a DB2 database (Workgroup Edition, V6.1) from a server running Windows NT 4.0, to a new server running Windows 2000. Since DB2 V6.1 is no longer supported by IBM, I cannot even find anything to tell me if V6.1 is compatible with Windows 2000. Also, the new server will be running two hyperthreading processors vs,...
1
2377
by: Robbert van Geldrop | last post by:
Hello, I have a problem restoring Exchange 2000 files. Our software has an interface to ESEBCLI2.dll for online backup and restore features. Everything works fine with Exchange 2003 and also when backing up Exchange 2000, yet restoring Exchange 2000 gives some problems: A Store is restored: * the restore is started.
11
4260
by: bill | last post by:
I dynamically create buttons and associate them with an event using AddHandler. I want all the button events to fire at one time, when the page is posted, instead of when each button is clicked. How I stop the buttons from posting back when they are clicked? Thanks
0
9803
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
9652
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10520
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10560
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10233
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7766
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5636
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5804
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3088
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.