Home Forums SQL Server 2005 Data Corruption DBCC - Could not repair this error. RE: DBCC - Could not repair this error.

  • September 3, 2012 at 7:07 am

    #1532953

    arunkumarco (9/3/2012)

    re-create indexes for those tables.

    GilaMonster (8/31/2012)

    Nalini D (8/31/2012)

    Did you try re-creating the indexes on the table?

    Won't work. The repair fixed the damage to the nonclustered index and some damage to the clustered index, but the remaining is also in the clustered index. There's no duplicate copy of the data to work from.

    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