• Excellent.

    If you find there is data you can't recreate, post again here and I'll try and help you salvage as much as possible from the DB.

    You may also want to do some checks on the hardware on that server, specifically on the storage system, to see if you can find a cause for the corruption.

    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