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 the proposed design are as follows:
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 ?
Based on you description, it seems that you want to upgrade two SQL Server 2008 instances and SQL Server 2005 instances to SQL Server 2012 Enterprise edition and keep the databases available during upgrade.
If I understand correctly, you can try to install side-by-side instance of SQL Server 2012 on each server. After the installation, backup the databases from the earlier version and then restore to the new instance. Remove the instances which is no need
on the server.
If you have any feedback on our support, please clickhere.