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
Last activity: Jun 5, 2025, 10:04 PM