• That's not the full output. If you want an accurate assessment of the damage and your options, please post the full and unedited output of the checkDB command (or save it to a text file and attach the file to your post if it's a lot of messages)

    You can run repair, but you'll lose data (error 823 is repairable). Can't tell how much without all the errors, but probably a lot

    Best bet for recovering with no data loss will be to restore a 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