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" 😉