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?