• sqlenthu 89358 - Monday, July 10, 2017 2:18 PM

    Thanks for the insight Grant. We have two new prod servers in one location and two DR servers in another location. We have rto of 2 hours and rpo is point of failure.

    No where near enough information to even start a DR design. No idea of databases, interdependencies, application servers, network setup, etc, etc.

    0 data loss?  That's not going to come cheap. You need redundant network connections between the data centers, high speed networks, synchronous 'DR' of some form, log backups that go offsite immediately, etc. It's not easy at that point.
    You need to look at other business restrictions, skills available in the admin team, budgets, and a lot of other things.

    If they need 0 data loss in the case of a disaster, any disaster, then they probably should get in a top-level specialist to help them get the right setup. I recommend Denny Cherry. He's not cheap, but their requirement is not going to be cheap and with DR the cost of getting it wrong is often the largest cost.

    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