Issue:
n
- n
-
Two Node Always ON Setup has been setup with Cluster Quorum enabled.
-
AlwaysOn Failover and DB failover is happening without any issues.
-
The application is working without any issues and there are no issues in the application process with connectivity to the second node.
-
Wherein whenever a new record is inserted in the primary node, data is not synced to the second node. though there are no issues in the second node Database failover and application side.
n
n
n
n
n
Solution:
n
After Many Cluster and Always ON validations and troubleshooting found the below solution.
n
n
After so much troubleshooting, Found that Database got suspended from Syncing primary from/to Secondary.
n
Step 1: Go to the Primary node of the Always On — AlwaysOn High Availability —Availability Databases — Right Click on <DBName> and Select Resume Data Movement
n
n
Select Continue Executing after Error and Click on OK
n
n
Now you can see the Database is healthy in the both the nodes as per Primary Node
n
n
As per the setting I have done Asynchronous-commit mode, Database should show as SYNCHRONIZING
n
n
But, Noticed it is still shows Not Synchronizing in the Second node as well, then did with the same by clicking on Resume Data Movement
n
n
n
n
Finally , Noticed Database synced well and all the records are getting synced from/to Primary Node to / from Secondary Node. without any issues. SQL Database
n
n
#AlwaysOn #SQL #SQL2014 #SQLAvailabilityGroup