• SQL-DBA-01 (11/29/2015)


    Hello Experts

    Can you please tell me how to find the exact time cluster took to failover to another node from existing?

    What are the typical places other than eventviewer I can check to get the time recorded? Does cluster.log file help?

    Please suggest.

    Thanks in advance!!!

    In Windows 2008 above the cluster.log does not exist, it can be created for support purposes with a static dump of the cluster events.

    To monitor cluster events use the Applications and services logs viewer within the Event viewer console.

    Event id 1201 for a cluster role coming online, event id 1204 for a role going offline.

    This link has further info

    https://technet.microsoft.com/en-gb/library/cc772342.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉