• Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

    Do you know how much data was lost?

    Do you know what data was lost?

    Do you know what effect that lost data will have on your business?

    Please run the following and post the full and complete, unedited output.

    DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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