Pros and Cons for DR solutions

Question

Post reply

Pros and Cons for DR solutions

Steve Dell

SSCarpal Tunnel

Points: 4623
More actions
November 29, 2010 at 12:32 pm

#146383

Hi Can some one shade light on pros and cons of DR solutions of
Mirroring, Log Shipping, geoClustering,Replication ?Thanks in advance ..:-)

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

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

I think that this link will pretty much give you what you're looking for.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

RamSteve (11/29/2010)
Hi Can some one shade light on pros and cons of DR solutions

There have been entire books written on that topic.

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

Steve Jones - SSC Editor SSC Guru Points: 736210 More actions · Answer 3

This white paper should help: http://msdn.microsoft.com/en-us/library/ee523927%28v=SQL.100%29.aspx

Note that what you need is a big limiting factor. What types of data loss, recovery interval, administrative cost, etc. can you talk about for your environment? Cost is a factor as well.