need answer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » need answer

need answer

Rate Topic

Display Mode

Topic Options

Author

Message

harri.reddy

Posted Tuesday, September 25, 2012 4:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346

hi

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

i need any article and anything you have .

thanks

Post #1364336

Evil Kraig F

Posted Tuesday, September 25, 2012 4:14 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:44 PM
Points: 5,677, Visits: 6,124

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

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1364344

Grant Fritchey

Posted Wednesday, September 26, 2012 3:46 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 13,380, Visits: 25,164

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 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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1364533

GilaMonster

Posted Wednesday, September 26, 2012 4:23 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722, Visits: 29,977

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 2008, MVP
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

Post #1364553

opc.three

Posted Wednesday, September 26, 2012 7:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:55 PM
Points: 6,720, Visits: 11,759

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

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1364688

« Prev Topic | Next Topic »

Permissions