Post reply

DR/HA proposal

  • March 11, 2013 at 5:59 pm

    #275108

    I need to write DR/HA proposal any suggestions?

  • March 12, 2013 at 1:34 am

    #1595835

    You can start from here http://download.microsoft.com/download/5/B/D/5BD13FFA-5E34-4AE1-9AA0-C6E6951B8FC8/SQL%20Server%202008%20R2%20High%20Availability%20Architecture%20White%20Paper.docx

  • March 12, 2013 at 5:27 am

    #1595910

    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

  • March 12, 2013 at 6:01 am

    #1595928

    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

  • March 12, 2013 at 10:16 am

    #1596116

    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/

  • March 13, 2013 at 2:33 pm

    #1596718

    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....

  • March 13, 2013 at 9:28 pm

    #1596791

    Do you have any HA/DR experience?

  • March 15, 2013 at 2:29 pm

    #1597685

    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