FIX: Error 976 occurs when you run DBCC CHECKDB on an unreadable secondary replica of SQL Server 2016 Availability Group

Velja za: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core


When you use the DBCC CHECKDB command to check a database of an unreadable secondary replica in a SQL Server 2016 AlwaysOn Availability Group, you receive an error message 976 that resembles the following:

Msg 976, Level 14, State 1, Line 1
The target database, 'Database_Name', is participating in an availability group and is currently inaccessible 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.


The fix for this issue is included in the following cumulative update for SQL Server:


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.