x

How to Setup DR site for SQl server

Hi

We have SQL server 2008 R2 with 2 instances 5 DB's( in OHio, Planing to set up DR in Dallas.)

Please explain me what are the best Disaster Recovery options available
more ▼

asked Jun 06, 2011 at 05:48 AM in Default

ETHMAN5 gravatar image

ETHMAN5
482 44 46 48

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

We wont be able to tell you what's best. That will be a decision made by your management (ie the business owners of the data) as they will need to decide on how much data they are happy to lose vs. how much they want to spend on the DR infrastructure.

What you need to do:
1 - Get together information about Replication, Mirroring, Log Shipping, UPS(or similar delivery service). Learn how they cover different sorts of outages and where they are good/bad. What administration they need. What hardware/licensing requirements they have. What training you and your team will need.

2 - put the key points of 1 into a document highlighting the considerations that management need to know. Ask them for their thoughts on data loss, expense of spare servers/network etc and then start to move in on a particular tech.

Once they are happy with what they are spending and how secure that makes them feel you need to learn that tech inside out and then confirm it will still do what they want for the investment they are making. If it's still rainbows and unicorns then that's your solution, if not you'll need to do the same for the next option.

Then implement chosen solution.
more ▼

answered Jun 06, 2011 at 06:26 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 75 78 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x11

asked: Jun 06, 2011 at 05:48 AM

Seen: 1403 times

Last Updated: Jun 06, 2011 at 05:48 AM