Shutdown Primary sqlserver service; 2 nodes with Default Quorum (Node Majority) setup;

SQL Cluster : 2 nodes with Default Quorum (Node Majority) setup;
Testing with Shutdown Primary sqlserver service and verify if the database failover to secondary Availability Replicas and secondary availability promote to Primary Replicas

Availability Group Properties
Synchronous commit , Failover mode = Automatics
SQL-A primary, SQL-B secondary




Shutdown SQL-A, SQLService to simulate Primary SQLServer (SQL-A) fail and see if the database will auto-failover to SQL-B

SQLServer SQL-B become Primary Replicas; Auto-Failover is happen when SQL-A fail.
From Replicas, we can see SQL-A become secondary and down



SQL AG (alwaysonag)Dashboard


SQL-B error log



SQL-B:
Availability Replica status : SECONDARY_NORMAL -- RESOLVING_NORMAL  -- PRIMARY_PENDING -- PRIMARY_NORMAL

Availability Group database status : SECONDARY - RESOLVING --PRIMARY

Bring back SQLService - SQL-A
SQL-B still act as Primary Availability Replicas
SQL-A is back online and show as Secondary Availability Replicas





SQL-B : SQL Error log