Post reply

DBCC checkdb

  • March 19, 2007 at 3:35 pm

    #171794

    After running DBCC checkdb, I got the following message,

    "The In-row data RSVD page count for object "Table1", index ID 0, partition ID 6656845414400, alloc unit ID 6656845414400 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE."

    What does this mean, what is RSVD?

  • March 20, 2007 at 8:16 am

    #695943

    that you should run DBCC UPDATEUSAGE to correct the count

  • March 20, 2007 at 11:53 am

    #696010

    RSVD = Reserved

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • March 21, 2007 at 8:29 am

    #696169

    Thanks Mike & Rudy. I ran DBCC UPDATEUSAGE as recommended by SQL Server. I want to know in detail what partition id and fragmentation id are and what are their differences (Also, what RSVD was.)

    Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

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