• Why no good backup?

    If checkDB with repair is not working, then your only remaining option is to script out the DB, bcp out what data you can (some won't export because of the corruptions) and recreate the database.

    It's very likely that the two tables with corruption won't export at all. You can try querying them in QA, but there are no guarantees. You may be able to get some of the data back though.

    Do you have a much earlier backup that you can salvage some data 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