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 characters needed characters left characters exceeded

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

Probably something to report to Microsoft.

what does select @@version return on your server?

0 Likes 0 ·

@KenJ Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

0 Likes 0 ·

1 Answer

· Write an 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 characters needed characters left characters exceeded

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

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.