locked
Witness Server Handover Logging RRS feed

  • Question

  • Is there any way to read a logfile to confirm that a principle and mirror server had a handover, and that the handover when back once the principle came online.

    In my enviroment we patch servers over the weekend and when i come to work on monday I want to be able to check that the failovers took place, without having to check each DB. I want to know if I can check it on the witness server

    Here is a simple example of what happens.

    • Server 1 (SQL Principle) is patched on Friday, and rebooted. Server 2 (SQL Mirror) take over as SQL principle.
    • Server 2 is patched on Saturday and Server 1 takes over as principle.
    • Server 3 (SQL Witness) is patched on Sunday.

    Is there a way to this?

    Tuesday, October 30, 2012 10:09 AM

Answers

  • Hello,

    In addition to checking the errorlog, if this is a high priority item it is possible to create an event notification for DATABASE_MIRRORING_STATE_CHANGE that can be acted upon. This could be logged to a table and then emailed, used with some external program to log up your monitoring chain, etc.

    http://msdn.microsoft.com/en-us/library/ms189453.aspx

    -Sean


    Sean Gallardy, MCC | Blog | Twitter

    Tuesday, October 30, 2012 12:13 PM
    Answerer

All replies