• GSquared (3/8/2011)


    I seriously recommend hiring a contractor who specializes in disaster prep and recovery and going over business needs, etc., with that person. It'll take some time and some (a lot of) work, but you'll end up with a better plan, more suited to your specific needs, than you will by asking a few questions on an online forum and getting a few short, generic answers.

    Seconded. This isn't trivial to do and getting it wrong is costly.

    Manvendra, you say cost isn't a constraint. So is geo-dispersed clusters, multiple SANs, multiple servers, multiple data centres and top-end fibre connections costing tens of millions of dollars feasible? DR at the top end is not cheap. I've never seen a client with an unlimited HA/DR budget, not even the banks where downtime is measured in millions of dollars a minute.

    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