Post reply

Events log

  • August 6, 2011 at 7:58 am

    #254942

    Hi,

    How events log are beneficially for DBAs. I Can understand it is more beneficially for systems engineers. If i think DBAs point of view, we get all information in error log file related to SQL then what information does not get logged in error log file and logged in events log.

    Thanks in advance.

  • August 6, 2011 at 8:17 am

    #1364779

    System errors and events. (and no, those aren't just for the system administrators to look at)

    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

  • August 6, 2011 at 8:19 am

    #1364781

    Hi Gail,

    Thanks for reply, is there any other information related to SQL logged in events log but does not log in error log file ?

    Thanks in advance.

  • August 6, 2011 at 8:26 am

    #1364784

    SQL's messages are logged in both. System messages only in the system event 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

  • August 6, 2011 at 8:29 am

    #1364785

    Thank you so much for replies.

Viewing 5 posts - 1 through 4 (of 4 total)

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