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

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 (mjorlando@xxxxxxxxxxxxxxx) 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, esquel@xxxxxxxxxxxxx
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.

Relevant Pages

  • Re: catalog is empty after populating
    ... SQL Server is installed as the "Microsoft Search" service cannot write it's ... Tools -> Event Viewer and review the Application event log. ... >is only 1 MB and the catalog doesn't contain any items. ...
    (microsoft.public.sqlserver.fulltext)
  • Full Text Indexing Error
    ... I see a lot of these in my Event log on the SQL Server for my Windows ... These documents will not be passed to MSSearch for indexing, ... therefore this failure will not be reflected in the end of crawl summary ...
    (microsoft.public.sqlserver.fulltext)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... Associated with this is event id 17055 from MSSQLSERVER w/description 18456: Login failed for user NT ... These messages occur in bursts of of over 100 messages every 5 minutes and just flood the application event log w/entries I think what's going on is the Alert Engine is a service running under local system and is unable to connect to SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot Connect to Configuration Database
    ... <Event Log> ... Source: Windows SharePoint Services ... the database connection information and make sure that the database server ... >> The install is in server farm mode and the SQL server is on another box. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: error message not being logged to windows event log
    ... Anon restarted SQL Server after making the changes which ... Logging to the Windows event log is enabled by default for ... log and the Windows Application event log if you haven't ... I thought the login audit logging only went to file ...
    (microsoft.public.sqlserver.connect)