top of page

SQL DATABASE IS NOT SYNCHRONIZING IN ALWAYSON SETUP

Updated: Dec 27, 2023

Issue:

  1. Two Node Always ON Setup has been setup with Cluster Quorum enabled.

  2. AlwaysOn Failover and DB failover is happening without any issues.

  3. The application is working without any issues and there are no issues in the application process with connectivity to the second node.

  4. 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.

Solution:

After Many Cluster and Always ON validations and troubleshooting found the below solution.

SQL

After so much troubleshooting, Found that Database got suspended from Syncing primary from/to Secondary.

Step 1: Go to the Primary node of the Always On — AlwaysOn High AvailabilityAvailability Databases — Right Click on <DBName> and Select Resume Data Movement

SQL

Select Continue Executing after Error and Click on OK

SQL

Now you can see the Database is healthy in the both the nodes as per Primary Node

SQL

As per the setting I have done Asynchronous-commit mode, Database should show as SYNCHRONIZING

SQL

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

SQL

SQL

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

SQL
11 views0 comments

댓글


bottom of page