Post reply

dbcc checkdb

  • October 24, 2003 at 2:19 pm

    #66151

    I have SQL 2000 sp3 running on win 2000 sp4.

    I run dbcc checkdb on a database and I get this error.

    DBCC results for 'Post_Detail'.

    Server: Msg 2576, Level 16, State 1, Line 1

    IAM page (0:0) is pointed to by the previous pointer of IAM page (1:251622) object ID 619149251 index ID 0 but was not detected in the scan.

    There are 665676 rows in 23264 pages for object 'Post_Detail'.

    I also ran dbcc checktable ('post_detail')

    and I did not get any errors.

    Any idea what it means?

    Thanks

  • October 24, 2003 at 2:34 pm

    #479563

    http://support.microsoft.com/default.aspx?scid=kb;en-us;816084

  • October 24, 2003 at 2:44 pm

    #479569

    Have you also run a dbreindex on the affected database recently? If so, check: http://support.microsoft.com/default.aspx?scid=kb;en-us;816084&Product=sql which details the same error message that you describe.

    This looks like a known bug that can be avoided by turning off Auto Update Statistics prior to running the reindex statement. Microsoft doesn't post a fix on the website, so you may have to contact product support if this is the problem. Hope this helps and best of luck.

    My hovercraft is full of eels.

  • October 24, 2003 at 3:56 pm

    #479578

    The dbreindex fix the problem.

    Thanks

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

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