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

Full recovery Mode is required Error

You may get the below error while you trying to enable AlwaysON for the Databases

1

To Resolve the Issue, Open the Database Properties

2

Enable the Full Recovery Model under Recovery Model which is Simple by Default. Now try to enable … 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