DATABASE IS NOT SYNCHRONIZING IN ALWAYSON SETUP

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. Application is working without any issues and there are no issues in the application process with connectivity
Continue Reading

Not able to create the SQL Availability Group

Not able to create the SQL Availability Group getting Below Error,

1

To resolve the issue, Open SQL Server Configuration Manager

2

 

Under AlwaysOn high Availability and select Enable AlwaysOn Availability Groups

3

4

Once AlwaysOn is enabled, Restart the SQL Services

5

6

Now … Continue Reading