SQL DATABASE IS NOT SYNCHRONIZING

SQL DATABASE IS NOT SYNCHRONIZING IN ALWAYSON SETUP

Issue: Solution: After Many Cluster and Always ON validations and troubleshooting found the below solution. 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 Availability —Availability Databases — Right Click on <DBName> and Select Resume Data […]

SQL DATABASE IS NOT SYNCHRONIZING IN ALWAYSON SETUP

Issue: n n Two Node Always ON Setup has been setup with Cluster Quorum enabled. n AlwaysOn Failover and DB failover is happening without any issues. n The application is working without any issues and there are no issues in the application process with connectivity to the second node. n Wherein whenever a new record […]