AG force failover to DR, then reconnect to Prod nodes. Will AG keep Prod data or DR data ?

 dans Sites Microsoft par

I made a test in my testing environment. Below are my test results

 

I have 3 nodes in this Alwayson. CPS2019VM3 is DR node. I set firewall rules in VM1 and VM2 to block all network traffics from/to VM3. You can see VM3 became ‘Resolving’ state.

 

 

 

 

 

I forced quorum using below command

 

 

 

Then I made a force failover allow data loss for AG.

 

 

 

 

I updated 1 row in VM3. I want to see if this data will be kept after resuming data movement.