We are running SQL on 2016 -SP2. DBCC on secondary non readable replica in AG is failing.
As per google this is fixed in
But it is not working for us on 2016-SP2.
Any help please
Attachments: 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?
@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)
Answer by shamim007 · Jan 11, 2019 at 06:41 PM
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
Thanks @shamim007 Will try and let you know
Answers Answers and Comments
19 People are following this question.
Finding Missing Child Rows
TempDB uses most of the memory
Do I Need a "Master" table?
enabling Broker in Availability Group (2012)
DTC Two Connections in one Unit of Work on One Server