Sample Header Ad - 728x90

Error "No catalog entry found for partition ID ..."

0 votes
1 answer
261 views
When trying to delete disabled index or enable the same disabled index on one heavily utilised table, I am getting an error: No catalog entry found for partition ID 72057594967228416 in database 6. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption. The database has different filegroups (one for table, one for indexes, ...) but no partitioning, no partition schemes, no partition functions. I can flawlessly create different index in the same filegroup with no error. DBCC CHECKDB('myDB') WITH ALL_ERRORMSGS, NO_INFOMSGS returns exactly **0** errors. My question: is the metadata damaged as in this case: Question DBA stack exchange or is there a way out? Thanks!
Asked by Sranda (360 rep)
Jun 28, 2024, 08:28 AM
Last activity: Jun 5, 2025, 10:04 PM