Post reply

need answer

  • September 25, 2012 at 4:08 pm

    #267241

    hi

    i need to know ,what will you do for disaster recovery for your database.

    i need any article and anything you have .

    thanks

  • September 25, 2012 at 4:14 pm

    #1542129

    harri.reddy (9/25/2012)

    hi

    i need to know ,what will you do for disaster recovery for your database.

    i need any article and anything you have .

    thanks

    :blink:

    You're not talking articles here, you're talking books and blogs and all sorts of information all over the place. This isn't a quick read subject, you're talking a month or two of dedicated research into options, choices, pros and cons, methodology, and all sorts of other things.

    What's driving this? The more information we have the more we can help direct you to the specific resources you're going to need. This is equivalent to asking "Describe the coolant plumbing of a nuclear reactor". At the surface it looks simplistic, but yeah, it's not.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 26, 2012 at 3:46 am

    #1542280

    It's a giant topic. But, as with everything else SQL Server, start with the Books Online. Microsoft Developers Network (MSDN) also has an example of a plan. And finally you can always rely on Simple-Talk[/url] to have a few articles on any topic within SQL Server.

    Those just scratch the surface of what's out there for this type of thing. They don't even get into using high availability and disaster recovery solutions from your SAN vendor. They don't cover some of the new HA & DR options with virtual machines either.

    It's a HUGE topic. I won't be able to provide you with enough links here to provide a truly meaningful answer. I'm with the last post, what specifically are you after?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • September 26, 2012 at 4:23 am

    #1542299

    Start with your SLAs. What is the RPO for that database (recovery point objective, or how much data may be lost)? What is the RTO (recovery time objective or how long the DB needs to be down)

    Without those, there is no DR plan that can even be considered.

    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

  • September 26, 2012 at 7:49 am

    #1542413

    Here is a good primer to set you in the right direction asking the important questions:

    Designing a Recovery Strategy for StackOverflow (December 16, 2009) by Brent Ozar[/url]

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

Viewing 5 posts - 1 through 4 (of 4 total)

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