I'm going to use AlwaysOn technology on my servers, but it's some unclear points in the documentation:
Automatic failover looks like
- Primary replica (A) unaccessable
- Secondary replica (B) becomes first replica
- When A become available it sets to secondary replica and get all changes from primary replica (B)
in documentation is written that:
Later, when the server instance that is hosting the former primary replica restarts, it recognizes that another availability replica now owns the primary role. The former primary replica transitions to the secondary role, and its databases become secondary databases. The new secondary replica connects to the current primary replica and catches its database up to the current primary databases as quickly as possible. As soon as the new secondary replica has resynchronized its databases, failover is again possible, in the reverse direction.
Does it mean that former primary replica (A) will become primary replica automatically? Or it (A) will be secondary and failover in reverse direction must be done manually?
Thanks for your help