August 13, 2009 at 6:01 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
August 13, 2009 at 6:30 am
Please run the following and post the full output.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup of this database?
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
August 13, 2009 at 7:52 am
when i try this i got the below error
MSG 8930, Level 16, State 3, Line 1
Database error: database xx has inconistent metadata. The error cannot be repaired and prevents dbcc processing. Please restored from a backup.
I'm using SQL 2005, SP2
August 13, 2009 at 8:10 am
Do you have a clean backup? (backup from before this problem started) This is not a repairable error.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/. There's a section towards the end on irreparable corruptions.
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
August 17, 2009 at 6:45 am
I tried to restore the clean backup, but that backup set also having the same problem. So it was failed.
i cross one of the post on 08/14 which occurs on the same error and you replied that, it is a bug on MS.
Regarding the cross post, Initailly i wrongly post in development area. then i post it administration post.
thanks for your guideness.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply