- Two Node Often ON Setup has been set up with Cluster Quorum enabled.
- AlwaysOn Failover and DB failover is occurring with out any concerns.
- Software is doing the job without any concerns and there are no challenges in the software method with connectivity to next node.
- Wherein any time new document is inserted in the key node, details is not obtaining synced to 2nd node. however there is no concerns in the next node Databases failover and application aspect.
Immediately after Many Cluster and Generally ON validations and troubleshooting identified the down below solution.
Just after so quite a few troubleshooting, Identified that Databases received suspended from Syncing principal from/to Secondary.
Stage 1: Go to Major node of the Constantly On — AlwaysOn Large Availability —Availability Databases — Correct Click on <DBName> and Choose Resume Information Movement
Find Proceed Executing immediately after Error and Click on Ok
Now you can see the Database is healthy in the each the nodes as per Major Node
As for each the placing I have accomplished Asynchronous-commit methodDatabases ought to display as SYNCHRONIZING
But, Observed it is continue to reveals Not Synchronizing in the 2nd node as very well, then did with the similar by clicking on Resume Info Motion
Lastly , Observed Database synced effectively and all the records are acquiring synced from/to Primary Node to / from Secondary Node. with no any problems.