Post reply

Need help for checkdb error

  • June 20, 2011 at 1:15 am

    #252205

    In one of the database in dev server faces a problem of checkdb consistency error,

    Here is the error

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

    what would be the cause of the problem?

  • June 20, 2011 at 2:49 am

    #1341008

    Is this database is restored/upgraded from SQL Server 2000? If yes, this is normal.

    Run DBCC UPDATEUSAGE. It should fix the issue.

  • June 20, 2011 at 4:44 am

    #1341036

    thanks for the information

  • June 20, 2011 at 5:43 am

    #1341085

    What Suresh didn't tell you is that databases upgraded to SQL 2005 can experience invalid page and row counts in the system catalog views. DBCC UpdateUsage corrects those counts.

    However, if you are on a SQL 2005 db that has not been upgraded and are experiencing this problem, you should probably contact Microsoft. According to their own documentation, that problem should not occur on SQL 2005 dbs.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 20, 2011 at 2:29 pm

    #1341449

    Iirc, the bugs in the page usage tracking were fixed in 2005 RTM, fixed again in 2005 SP1 and fixed again in SP3. (or something like that)

    If you're post SP3 you should not get new cases of this, it should just be a once-off fix of legacy stuff.

    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

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

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