Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need answer Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2012 4:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, September 25, 2012 4:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 5,384, Visits: 7,458
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
Posted Wednesday, September 26, 2012 3:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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 Query Performance Tuning
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
Posted Wednesday, September 26, 2012 4:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 39,977, Visits: 36,340
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
Posted Wednesday, September 26, 2012 7:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
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
Post #1364688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse