Issue:

n

    n

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

  2. n

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

  4. n

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

  6. n

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

  8. n

n

Solution:

n

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

n

SQL

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 AvailabilityAvailability Databases — Right Click on <DBName> and Select Resume Data Movement

n

SQL

n

Select Continue Executing after Error and Click on OK

n

SQL

n

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

n

SQL

n

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

n

SQL

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

SQL

n

n

SQL

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

SQL

n

#AlwaysOn #SQL #SQL2014 #SQLAvailabilityGroup

Leave a comment

Your email address will not be published. Required fields are marked *