To which secondary replica does it get failed over?

  • Good Morning Experts,

    In SQL Server 2016, 3 synchronous replicas can be designated as failover targets in Alwayson Availability Group. My doubt is that if automatic failover triggers, to which secondary replica does it get failed over?

  • coolchaitu - Monday, July 3, 2017 12:23 AM

    Good Morning Experts,

    In SQL Server 2016, 3 synchronous replicas can be designated as failover targets in Alwayson Availability Group. My doubt is that if automatic failover triggers, to which secondary replica does it get failed over?

    You may want to post this in the appropriate forum section.

    the one that's configured for automatic failover, if not defined its a sequential list

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

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