Post reply

DBCC CHECKDB error

  • October 3, 2006 at 6:43 am

    #170532

    Hello everyone,

    We have some consistency errors in a database found by CHECKDB.

    Here are, among others, some example of the error we have:

    Object ID 2: Errors found in text ID 1639776256 owned by data record identified by RID = (1:24:0) id = 1 and indid = 1.

    Object ID 2: Errors found in text ID 1048576 owned by data record identified by RID = (1:24:17) id = 12 and indid = 2.

    Object ID 2: Errors found in text ID 6475087872 owned by data record identified by RID = (1:31:13) id = 18099105 and indid = 2

    How can I diagnose those errors? What is the difference between OBJECT ID 2 and id=1 ?? How can I found TEXT ID refers to what? I would like to foud exactly where is the problem because we had these error twice in the recent past. We have then deleted the database, deleted the files (datafile et transaction log file) recreate it and reload the data from a BCP export. Once the database is rebuild, CHECKDB is ok for a week or two and the same error happens again.

    Thanks for your help on this one.

    Carl

  • October 3, 2006 at 7:50 am

    #663826

    Hi Carl,

    Do you have any error messages in the errorlog?

    Regards,

    Holger

  • October 3, 2006 at 8:16 am

    #663842

    Hi Holger,

    I found this (spid5):

    Table error: IAM page (1:166529) (object ID 2, index ID 255) is out of the range of this database.

    And for sure, this error concerning the CHECKDB:

    DBCC CHECKDB (con2006_sto) executed by GIRO\admsql found 2118 errors and repaired 0 errors.

    Best regards.

    Carl

  • October 3, 2006 at 9:17 am

    #663860

    Hi Carl,

    I think you've hit a nice known bug in SQL Server.

    Have a look on this article:

    http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B892803

    Regards,

    Holger

  • October 3, 2006 at 9:33 am

    #663866

    Hi Holger,

    Your were right! Its taht bug.

    Thanks a lot.

    Carl

  • October 3, 2006 at 9:43 am

    #663872

    Hi Carl,

    No problem. At least there's an easy workaround for it.

    Best regards,

    Holger

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

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