Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.