Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I currently have an ASP.NET web app running on a cluster in a data center talking to a SQL Server DB. I need to make this setup redundant with a hot-hot DB in another data center as well as a replicated web cluster.

What architectural options are available to setup this type of fail-over?

share|improve this question

Sure, gotcha, I apologize, i'm a bit new here, this is an awesome site!

For the proposed solution I would recommend 3 tiers of redundancy in a multi-threaded setup.

Database- Continue to use SQL in a cluster configuration, 2 nodes with a DRBD RAID10 pair of storage systems to keep the data up and running. In the event of Datacenter failure (worst possible case) have a 3rd tier passive replica at another datacenter with transaction logs being shipped.

Web- 2 Web servers, local data stored on a seperate set of drives RAID1 or RAID10 depending on size and I/O. Replicate data via Robocopy. Added performance and requirement for 100%, incorporate dedicated load balancers in a pair. Additional replica web server at a seperate datacenter.

share|improve this answer

it depends on how current you want your data and how much data you will be transfering.

share|improve this answer
The idea is to keep two hot-hot SQL Server DB's at different physical locations so that if one goes down there is no interruption in service. Is this even possible? – Guy Jul 28 '09 at 15:11
real time synchronization isn't likely without high expenses, especially if you have a lot of data transferring around. clustered failover servers w/ a quality san and reliable backup routines would be a much easier solution to implement. – Keith Jul 28 '09 at 21:22

noneil, I think the point of the site is to encourage community problem solving. Lets have some open discussion so other people can benefit from having this question answered here.

share|improve this answer
Please keep comments in the comments fields. This has nothing to do with the actual question. – phuzion Jul 28 '09 at 21:33
bien, wasnt sure how to add these before. Thanks! – dubRun Jul 29 '09 at 12:45

I do a lot of work involving these kind of solutions and meeting high levels of redundancy and compliance. I can do you a solid and offer recommendations.

let me know if you want to chat, have a good one.

share|improve this answer
I'm looking for community discussion/problem solving on this one. – Guy Jul 28 '09 at 15:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.