What if I have Asynchronous replica within the AG?? this query still shows Synchronizing for the Asynchronous replica i.e. Node3, Node4, Node5. Can't I move forward, what can I do at this time??
FYI, I have already completed the 1st step
SELECT ag.name
, drs.database_id
, db_name(drs.database_id) as database_name
, drs.group_id
, drs.replica_id
, drs.synchronization_state_desc
, drs.last_hardened_lsn
FROM sys.dm_hadr_database_replica_states drs
INNER JOIN sys.availability_groups ag on drs.group_id = ag.group_id;
My Architecture overview:
Physical data center:
Node1 (Synchronous)
Node2 (Synchronous)
Node3 (Asynchronous)
Node4 (Asynchronous)
Node5 (Asynchronous)
Cloud:
Node1 (Synchronous)
Node2 (Synchronous)
Node3 (Asynchronous)