none
SQL Server 2012 non cluster availability design consideration

    Question

  • Hi,

    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:

    PRODSQL1
    PRODSQL2

    and then

    DRSQL1
    DRSQL2

    respectively. 

    and the proposed design are as follows:

    PRODSQL2012-1
    DRSQL2012-1

    only.

    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 ?

    /* Server Support Specialist */

    Sunday, June 30, 2013 10:46 AM

Answers

  • Hello,

    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.

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click  here.


    Fanny Liu
    TechNet Community Support

    Tuesday, July 02, 2013 7:07 AM
    Moderator