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

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in two different sites (1 x physical server in PROD and 1 x physical server in DR with different geographical location and VLANs as well) ?

Because my understanding with SQL Server 2008 R2 (I Installed on top of the MSCS 2008 R2) is that I will need 2 nodes in each site as follows:


and then



and the proposed design are as follows:

PRODSQL2012-1 DRSQL2012-1


The problem is that not all of the Tier-1 app database has got Mirorring or Transaction log shipping capability, so I wonder what should I do to avoid major Database outage when I patch the PRODSQL2012-1 ?

share|improve this question

Your Answer


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

Browse other questions tagged or ask your own question.