Post reply

Database mirroring

  • August 11, 2010 at 7:17 am

    #142353

    Hello,

    Can u please assist here ,

    I have a scripts that alert DBA's when the manual\automatic fail over occurs in a db mirroring environment ,now i need another script or way that will show who (PERSON) did\activated fail over.

    Thanks

    Miranda.

  • August 11, 2010 at 8:40 am

    #1205399

    I wouldnt know off-haand how this would be acheived but you would almost certainly need to turn on a higher level of logging.

    Is this a frequent problem?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • August 11, 2010 at 8:59 am

    #1205417

    thanks for replying

    Not frequently but i would love to know what user activated\resulted to the failover when it happens,please elaborate what do you mean by higher the loggins ?

    Thanks

    Miranda

  • August 11, 2010 at 9:03 am

    #1205420

    I'm not sure exactly whats involved but i do know that there is a higher level 'auditing' that can be turned on. As it suggests this loggs a lot more info (not just when things go wrong).

    If you monitor the logs frequently, this could generat a lot of 'noice'.

    Check out BOL and let me know what you find. 😉

    Adam Zacks-------------------------------------------Be Nice, Or Leave

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

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