Theoretical question - Hyper-V / Server / SAN replication - Disaster recovery.

At the end of the year, we are to replace some servers for a customer. They are thinking about disaster recovery and damage limitation if one of their buildings should flood, or go up in flames etc., and because of this they are going to have a physical server and SAN in their main building and a duplicate physical server and SAN in a satellite office, both of which are connected via a fibre link and will replicate data.

The "plan" is that one server/SAN will be the primary, and the other will act as a backup - the two will replicate. So far so good - users will still be able to log on and access data.

Now, my question is this. Supposing, the fibre link between the two buildings goes down or gets cut (as one recently did at this site - by a careless contractor!). If one combination of server/SAN is serving the main building and the other server/SAN is serving the satellite office, what happens when the fibre link is restored?

The physical servers will have 4 Hyper-V guests, 3 of which will have SQL applications such as CRM, SharePoint, Document management etc....

My concern is will one set of data overwrite another, or will the SQL databases be able to "merge" any differing records with the same record IDs etc?

I've never done anything like this before and I just want to understand what would happen in this scenario.

Thanks.
LVL 17
Chris MillardAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dipopoCommented:
Hello,

Ideally for a workable DR solution, all writes should go to the Primary location, hence the primary gets replicated to secondary and in the event of failure.

All primary site activities fail over to the secondary, I would just have 1 way replication from Primary to secondary using the storage vendors replication software, supposedly the MS SQL server LUN(s) are physcal RDM's which can be replicated by the storage as well.

Note that you *will* need to reverse the replication in order to fail-back the solution.

Hence my best advice is to talk to your storage vendor regarding what available solutions they have [VSS aware snapshots, replication], based on available functionality they will suggest a best fit solution.

Out of further interest what storage do you have in use?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris MillardAuthor Commented:
At the moment, nothing yet - but it looks like it's going to be a Dell SAN solution.
0
dipopoCommented:
I'd speak to a storage specialist at Dell. You can peruse some of their offerings here.

http://www.dellstorage.com/compellent/software/data-protection/

http://www.dellstorage.com/compellent/software/storage-continuity/
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.