Post reply

turning off logging in sql error logs

  • July 27, 2004 at 6:43 pm

    #161287

    Hi All,  Kinda stupid question.  Is there anyway to stop certain kind of status information to  show up in sql error logs.  We have multiple db's whose logs get backed up pretty frequently.   How can I stop "log backed up database: ??"  entries from showing up in the sql error logs.  Thx in advance..

     

     

    wize

  • July 27, 2004 at 8:49 pm

    #516444

    Firstly, why do you want to turn them off?? Is your log getting to big? If so, why not use sp_cycleerrorlog to create a new log file. You can adjust the number of logs to keep in the registry.

    In answer to your question,

    In EM, goto Tools|Manage SQL Server Messages...

    Type in some of the message text (eg: Log Backed Up)

    Press search and you'll get a list of messages where that text appears.

    Then you can edit the message and turn of the 'Always Write to Windows Event Log' option.

    --------------------
    Colt 45 - the original point and click interface

  • July 28, 2004 at 12:00 pm

    #516638

    well,  your answer was pretty close but not quite complete.. Messages such as "log backed up" are system messages and thus cannot be deleted from the "manage sql server messages" interface.  I tried something else, which I don't think is very wise... I deleted that particular message from sysmessages, but the transaction still gets logged in the sql error log.  No, I am not worried about the sql error logs getting too big, I was just curious to find out if there was a way.  I appreciate your response.   Thx.

     

     

    wize

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply