Post reply

Disaster Recovery Plan

  • July 26, 2011 at 6:22 am

    #241311

    As part of my DRP i do daily full back-ups stored on disc.i have also set-up database mirroring.In case of:

    1.principal server crushing---i promote the mirror

    2.both servers crushing---i restore the most recent back-ups

    3.etc

    How good is such a strategy?Any Suggestions and improvements to this plan?

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • July 26, 2011 at 6:46 am

    #1358455

    Where do you store the backups?

    What happens if the server room becomes unavailable (power outage, fire, etc)?

    Can you restore the backup and keep to your downtime SLA?

    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

  • July 26, 2011 at 6:50 am

    #1358458

    1. are the servers geographically isolated from each other?

    do you have automatic fail over?

    have you tested the fail-over and made sure any systems that connect to the sql server are fail-over aware?

  • July 26, 2011 at 6:54 am

    #1358463

    Currently the application is not fail-over aware,servers are geographically isolated though in the same city.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • July 27, 2011 at 3:36 am

    #1359027

    What are your RPO and RTO?



    My blog

  • July 27, 2011 at 5:17 am

    #1359074

    My RTO is 48 hours and my RPO is 48 hours.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • July 27, 2011 at 5:39 am

    #1359098

    kapfundestanley (7/27/2011)

    My RTO is 48 hours and my RPO is 48 hours.

    How big's the db???

    I could restore from last Chrismas to ten years from now will all the tlogs with that big of a window... 😉

  • July 27, 2011 at 10:00 am

    #1359436

    Ninja's_RGR'us (7/27/2011)

    kapfundestanley (7/27/2011)

    My RTO is 48 hours and my RPO is 48 hours.

    How big's the db???

    I could restore from last Chrismas to ten years from now will all the tlogs with that big of a window... 😉

    😀



    My blog

  • July 27, 2011 at 10:02 am

    #1359440

    kapfundestanley (7/27/2011)

    My RTO is 48 hours and my RPO is 48 hours.

    Ninja's question was a very good one. How big are your DBs?



    My blog

  • July 27, 2011 at 10:04 am

    #1359443

    How long does the restore of your databases take? Do you have a detailed description of your recovery process. Do you have a replacement in case you will not be able of execute the restore?



    My blog

Viewing 10 posts - 1 through 9 (of 9 total)

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