• elie.etaxpoint (4/26/2016)


    Hi,

    🙁 Our last daily backup was last April 24, on April 25 it fails 🙁 can't restore to it.

    And the backup before that? Or older ones? What's the newest backup that will restore (hint, the last time your scheduled checkDB ran successfully should be a hint. You do have scheduled integrity checks, right?)

    Looks like the flash drive has failed. It does happen. Was it not in a RAID array? That would at least save the data long enough to get it somewhere else.

    Can you post the latest SQL error log? There may be entries in there that suggest when the problems started.

    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