Error in accessing availability replica in Always on environment
The target
database, ‘YourDatabase’, is participating in an availability group and is
currently not accessible for queries. Either data movement is suspended or the
availability replica is not enabled for read access. To allow read-only access
to this and other databases in the availability group, enable read access to
one or more secondary availability replicas in the group. For more information, see the ALTER
AVAILABILITY GROUP statement in SQL Server Books Online. (Microsoft SQL Server,
Error: 976)
Go to Primary server and
check availability dashboard. If any one server is in not synchronizing state.
Log on the server which in not synchronizing state.
Step 1 -> Run query
Alter DATABASE YourDBName SET
HADR RESUME
Comments
Post a Comment