DR/HA proposal

  • I need to write DR/HA proposal any suggestions?

  • Yes, consider hiring someone who has setup DR/HA before to guide you through the process.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Sen1 (3/11/2013)


    I need to write DR/HA proposal any suggestions?

    Do you have any HA/DR experience?

    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
  • Like many subjects there's no magic solution and you have to figure out what works best for your organisation vs the cost and complexity.

    DR and HA are different subjects anyway.

    At the most simple level failover clustering and log shipping work well - I've usually found the sql server ( database ) solution is the simpliest part of finding a DR/HA solution for a whole application.

    Handling data feeds, web sites, application tiers, web services, reporting, exports, logins, users, AD etc. are usually more of a challenge.

    Oh and usually the "how much?" when you provide suggested solutions!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • Colin is correct. HA and DR are two totally different animals. It is my opinion that you should first discuss with management and business units to determine their acceptable amount of data loss and time-to-restore parameters, and all others that are associated. Normally, these would then determine the HA and DR course that should be chosen. Can't create a plan until you know what you are trying to achieve, as different tools in the toolbelt are used for different requirements.

    Just my 2 cents....

  • Do you have any HA/DR experience?

  • opc.three (3/12/2013)


    Yes, consider hiring someone who has setup DR/HA before to guide you through the process.

    +100

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply