• Depending on how long this has been in the DB, you have two options:

    1) Restore a clean backup and all transaction log backups since that, to get the DB back to the current point in time. You do need ALL log backups.

    2) Take the DB into single user mode and run CheckDB ('medmas', REPAIR_ALLOW_DATA_LOSS)

    In this case it should not lose any data, but check before and after row counts in the table EHRChartDetail to be sure. You should take a backup before doing the repair so that, if necessary, you can revert or copy removed data from the 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