question

rehaan avatar image
rehaan asked

DBCC on non readable secondary server in AG is failing

HI,

We are running SQL on 2016 -SP2. DBCC on secondary non readable replica in AG is failing.

As per google this is fixed in

https://support.microsoft.com/en-us/help/3194923/fix-error-976-occurs-when-you-run-dbcc-checkdb-on-an-unreadable-second

But it is not working for us on 2016-SP2.

Any help please

sql serverdbccavailability-groups2012ag
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·

Probably something to report to Microsoft.

what does select @@version return on your server?

0 Likes 0 ·
Show more comments

1 Answer

·
shamim007 avatar image
shamim007 answered

had same issue after updating "Hotfix for SQL Server 2016 SP2 CU4" ,i think you just have to CU4 ,if you are not happen to apply CU3 go ahead and try to apply CU3 first .i think that will solve your problem

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rehaan avatar image rehaan commented ·

Thanks @shamim007 Will try and let you know

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.