October 28, 2020 at 2:34 pm
I'm testing the failover process in my AG that is using Asynchronous availability mode. In the scenario where I manually failover from Server A (primary) to B, what is the process to fail back to A? It seems like the only way is to rebuild the entire synchronization from B to A, failover to A, and then repeat the synch rebuild.
In synchronous mode, manual failovers are a breeze since the synch process resolves itself after the failover, but asynch doesn't behave that way in my environment. Is this expected?
October 29, 2020 at 11:22 am
In a two-node AG you should have Primary and a sync secondary. As you have said, failover is easy because the secondary is sync. When you failover, both nodes will still be in sync mode - the minimum configuration, as far as I know, is one sync secondary.
If you have several nodes and need to failover to an async secondary you can either set it to sync first, or you can force the failover and accept the possibile risk of data loss.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply