Post reply

Index corrupted in table

  • November 2, 2011 at 2:17 am

    #250227

    Error: 9100, Severity: 23, State: 2. Possible index corruption in sql server 2008 server

    How to do resolve this index corruption

    Any one could help for me?

    Thanks

    Jerry

  • November 2, 2011 at 2:44 am

    #1402010

    Please run the following and post the full and complete results:

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Got a clean backup?

    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

  • November 3, 2011 at 3:29 pm

    #1402964

    If not clustered index, drop and recreate the index.

    Alan

  • November 3, 2011 at 9:30 pm

    #1403034

    This is Clusterd index. what to do ?

  • November 4, 2011 at 2:52 am

    #1403109

    GilaMonster (11/2/2011)

    Please run the following and post the full and complete results:

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Got a clean backup?

    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