Page error

Question

Post reply

Page error

dba_neo

SSCrazy

Points: 2673
More actions
January 14, 2010 at 1:28 pm

#218221

Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 873822225, index ID 1, partition ID 338741790048256, alloc unit ID 338741790048256 (type In-row data). Keys out of order on page (1:180554), slots 2 and 3.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'tblTime' (object ID 873822225).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Apps'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (Apps).

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Is that the only error? If not, please post the results of this

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Drop the clustered index on tblTime and recreate it. That should fix this error. Run checkDB afterwards and make sure there's nothing else wrong.

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

dba_neo SSCrazy Points: 2673 More actions · Answer 2

Thanks Gail,

I ran DBCC CHECKDB() with WITH NO_INFOMSGS, ALL_ERRORMSGS

i got error as specified earlier,how can it be resolved.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 3

As Gail suggested Drop the clustered index on 'tblTime' and recreate it.

Then run the checkdb statement again.

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

kumar.kunda (1/14/2010)
i got error as specified earlier,how can it be resolved.

If you read my post, I told you how it can be resolved.

Drop the clustered index on tblTime and recreate it. That should fix this error. Run checkDB afterwards and make sure there's nothing else wrong.

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

What's the definition of the clustered index, and what are the data types of the columns that make it up?

What version of SQL is this? (run SELECT @@version)

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

dba_neo SSCrazy Points: 2673 More actions · Answer 6

thanks Gail,

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

And the definition of the clustered index (data types of the key columns)?

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