How can we help you today? How can we help you today?

Turn off entries in Application Log

Is there a way to turn off writing to the Application Event Log upon RESTORE or BACKUP?
GaryHampson
0

Comments

2 comments

Sort by
  • petey
    If you are referring to message such as these :
    18264 : Database backed up: Database: pubs, creation date(time): 2006/11/15(06:27:44), pages dumped: 2715, first LSN: 137:326:1, last LSN: 137:328:....
    these messages are generated by SQL Server, and are generated for both native and third-party backups. I don't know of any option to turn this off.
    petey
    0
  • Brian Donahue
    It's not terribly intuitive, but it is possible by setting a SQL Server trace flag:

    DBCC TRACEON (3226, -1)

    To persist the setting between reboots, go into the server properties and then the startup parameters, and add -T3226. Otherwise you will get event logging again if you restart SQL Server.

    This should stop SQL Server from writing backup events to the event log. If you have enabled event logging for the job in the SQL Agent's job properties, that would probably override the trace flag, so you would want to check the notifications tab of your job properties to make sure it's not going to get logged that way.

    I hope this helps!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.