Post reply

SQL Server Error Log

  • September 25, 2015 at 7:28 am

    #399092

    in my work i have had the responsibility of SQL DBA

    i am not the only one in sysadmin and serveradmin group

    the server issues many server errors in the log

    and suddenly stop logging any event error in server error log

    i have a Suspicion that some one else prevent the server from logging the errors

    if is that possible

    please tell me how

  • September 25, 2015 at 8:18 am

    #1829473

    It's not possible to stop SQL from logging to the error log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 27, 2015 at 9:39 am

    #1829758

    is

    exec sp_altermessage 17204 , 'WITH_LOG', 'false';

    GO

    and

    select * from sys.messages where message_id=N'17204'

    prevent sql server from logging event error

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

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