Post reply

SQL error in error logs

  • February 17, 2009 at 2:22 am

    #200090

    Hi Guys,

    I am currently have an the following error in the SQL error logs:

    2009-02-16 16:49:50.720spid110Unable to find index entry in index ID 2, of table 2137058649, in database 'ServerName'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

    These are the following errors I receive when running DBCC checkdb:

    Incorrect PFS free space information for page (1:41681) in object ID 2089058478, index ID 0, partition ID 136908536414208, alloc unit ID 136908536414208 (type In-row data). Expected value 95_PCT_FULL, actual value 100_PCT_FULL.

    Table error: table 'TableName'(ID 2137058649). Data row does not have a matching index row in the index 'PK_FileClassification' (ID 2). Possible missing or invalid keys for the index row matching:

    Msg 8955, Level 16, State 1, Line 1

    I narrowed the errors down to 3 tables. I ran DBCC checktable (TableName, REPAIR_ALLOW_DATA_LOSS) on 2 tables because the Repair_Rebuild option did not work for the 2 tables.

    I did all this on a test machine and did a record count on each table. It seems like only one has gained extra rows. The other 2 tables still have all the data.

    Can anyone advise me on other solutions to fix these errors or is the solution above suffice. I would like to be fully prepared before I take this to production.

    Regards

    IC

  • February 17, 2009 at 3:55 am

    #945051

    Try droping and recreating indexes.

  • February 17, 2009 at 3:58 am

    #945053

    Hi,

    I think this might help you to resolve your problem http://www.sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx. And also I think there is a video on DBCC CHECKDB by paul.

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • February 17, 2009 at 7:16 am

    #945170

    Please read this article as it covers all you need to know for your situation: http://www.sqlservercentral.com/articles/65804/

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • February 18, 2009 at 12:15 am

    #945696

    Thanks to all for ur help.

    All ur advice and articles given, really helped with understanding the problem.

    Cheers

    IC

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

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