Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Prevent SQL events of type "Information" being logged in the Application Event log.


Is there a way to configure SQL to only log events of type "Error" and "Warning" to the Applicaiton Event log?

The end goal is to eliminate the constant dribble of SQL Information events to the Application  log.

2 Solutions
James MurrellProduct SpecialistCommented:
use but i have seen a member of staff use
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
it appears this may not be possible

on the other hand, if you setup a limit to the size of the event log you will hardly retain more then absolutely needed minimum of events on hand, in case you need to troubleshoot an issue. So, the impact of accumulating messages can be effectively managed. I understand that some of the messages prompted this reaction, and to be 100% honest, I do not know why it is done this way. But I do know first hand that trace collecting applications normally try very hard to provide features to gather data accurately and with minimal impact on system, while rarely do provide for in place removal of entries. Those normally do offer some extension to load trace into a file or a database table to maintain the content to the users heart desire. This approach is not specific to any specific product but a mindset of all tracing applications I can recall off hand.

If you would like to have a better picture of events accumulated over time you may want to look at Microsoft System Center Operations Manager 2007, available here for download and evaluation: http://www.microsoft.com/downloads/details.aspx?familyid=C3B6A44C-A90F-4E7D-B646-957F2A5FFF5F&displaylang=en.
DextertronicAuthor Commented:
I'm going for the -n start up option.
These SQL databases do nothing but drive Arcserve databases and as such I can live without their constant drivel.

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now