Home Forums Database Design Disaster Recovery Copy off original data, even if it is corrupt - before restoring backups? RE: Copy off original data, even if it is corrupt - before restoring backups?

  • SkyBox (5/5/2011)


    What would you recommend for my situation?

    Get someone in to advise you on a high-availability setup.

    Zero downtime is near-impossible. Close to 0 downtime is expensive, the closer to 0, the more expensive it becomes. If you have near-0 downtime allowance, you cannot be depending on backups for recovery, you need some form of high availability setup. What precisely depends on your available hardware, budgets and a whole lot of other factors

    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