Forum Discussion
StuartRDH
Jul 22, 2024Copper Contributor
DBCC CHECKDB / CHECKCATALOG Error 3853
Version: SQL Server 2019 (RTM-CU25) (KB5033688) - 15.0.4355.3 (X64), Enterprise Edition, Windows When running DBCC CHECKDB or CHECKCATALOG we recently started getting the following errors: Attribut...
null null
Jul 29, 2024Copper Contributor
It seems DBCC CHECKDB was not working as excepted the causes fundamental inconsistency occured, as we can see error the above some objects doesnot matching row (Primary key and foreign key)
and MS suggested work around was TAB LOCK Hint.
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/8967-8921-errors-running-dbcc-checkdb
and MS suggested work around was TAB LOCK Hint.
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/8967-8921-errors-running-dbcc-checkdb