Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption)

Question

Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption)

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Dell Dude Mr or Mrs. 500 Points: 591 More actions · Answer 1

Yes that's all that is output. Unless I am missing something obvious.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

In that case, since you have no clean backup, you're going to have to drop and recreate the table. If the data's important, you should be able to do a bcp out or similar to export the data prior to the table drop.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dell Dude Mr or Mrs. 500 Points: 591 More actions · Answer 3

GilaMonster (2/2/2015)
In that case, since you have no clean backup, you're going to have to drop and recreate the table. If the data's important, you should be able to do a bcp out or similar to export the data prior to the table drop.

Thanks for your help!