August 13, 2009 at 7:54 am
We found the below error while i'm trying to access / delete the table in one database.
Error message
No catalog entry found for partition ID 7904115224647558 in database 26. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.
Because of the table, i'm unable to run the dbcc checkdb option.. it hurts my entire database. Kindly help me to resolve the same
We are using SQL SERVER 2005 & SP2
August 13, 2009 at 1:27 pm
Could not find an entry for table or index with partition ID %I64d in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.
As per the link mentioned below find the concerned objectid/objectname and drop/recreate it.
http://msdn.microsoft.com/en-us/library/cc645611.aspx
HTH!
MJ
August 13, 2009 at 10:54 pm
The error which i got it different. even i run the dbcc check db. i got the below error message
database error: database xx has inconsistent metadata. This error cannot be repaired and prevents further dbcc processing. Please restore from the backup.
August 14, 2009 at 1:36 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Question asked and answered here: http://www.sqlservercentral.com/Forums/Topic770068-145-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply