Post reply

Always On Failover Information

  • October 3, 2017 at 9:00 am

    #323913

    Hi All,

    Can any one tell me where can i find failover information of SQL  AG group and who failed over in case of manual failover?

    Thanks,
    Sunny

  • October 4, 2017 at 2:12 am

    #1962207

    If you right-click on the Availability Group name and click Show Dashboard, there is some information at top right under View AlwaysOn Health Events. It's not the friendliest format. It won't explicitly say (e.g.) "Joe Bloggs failed the database over at 17.45" or anything as useful as that.

    There's also information in the SQL error log, and (probably) in the AlwaysOn_health Extended Events session (Management > Extended Events > AlwaysOn_health but I don't have a recent enough example to hand to check). The default trace. The cluster event log too.

  • October 4, 2017 at 2:42 pm

    #1962359

    Beatrix Kiddo - Wednesday, October 4, 2017 2:12 AM

    If you right-click on the Availability Group name and click Show Dashboard, there is some information at top right under View AlwaysOn Health Events. It's not the friendliest format. It won't explicitly say (e.g.) "Joe Bloggs failed the database over at 17.45" or anything as useful as that.

    There's also information in the SQL error log, and (probably) in the AlwaysOn_health Extended Events session (Management > Extended Events > AlwaysOn_health but I don't have a recent enough example to hand to check). The default trace. The cluster event log too.

    Thanks Beatrix, Is there any way we can setup to log the fail over infor?
    -Sunny

  • October 5, 2017 at 2:54 am

    #1962416

    Not that I know of, I'm afraid. It would be handy. (Maybe somebody else knows.)

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

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