I’m wondering with High Availability, what happens if the connection between the Primary and the Secondary stops working?
I thought that both the primary and the secondary would stay available but the Secondary would begin lagging. Especially if we have Automatic Failover turned off.
Or would the Primary and/or the Secondary become unavailable?
The primary node would still be available when the connection with secondary is lost. As long as there is Quorum available to keep the availability group online.
But, having secondary disconnected for longer time may have effect on the primary node’s log file and cause disk full.
with automatic failover off, the primary remains available, the secondary remains available but stale, and neither is forced offline just because the connection between them drops