none
Upgrading SQL Server 2008 Standard to SQL Server 2014 Standard (with MS-Cluster, 2 nodes) - I need Help with Upgrade Plane

    Question

  • Hello Everyone

    I have SQL Server 2008 engine installed on two nodes with MS-Cluster. The whole system installed on hyper-v environment and the operating system is Windows Server 2008 R2 64-bit Standard.

    The system works fine without any issue and the cluster working just fine.

    Now, I want to upgrade the SQL server to 2014 standard edition and I have few hours to shut down the DB servers. So, I need to setup an upgrade plan and work according it. I need your help with that plan.

    I suggest to do the upgrade by implementing the following steps:

    1- Take Full backup of all DB attached to the SQL server.

    2- Install windows server 2008 R2 SP1 on both servers (as a requirement of SQL Server 2014).

    3- Turn off the SQL services on both nodes.

    4- Upgrade Node 1 SQL server 2008 Standard to SQL Server 2014 Standard.

    5- Upgrade Node 2 SQL server 2008 Standard to SQL Server 2014 Standard.

    6- Run SQL services.

    7- On node 1, test the system.

    8- Move SQL services to node 2 from MS-Cluster

    9- On node 2, test the system.

    Notes:

    -------

    1- The current license of SQL Server 2008 is for 4-Cores x 2 (VM) servers (Total 8 Core)

    2- The new license of SQL Server 2014 is for 2-Core x 2 (VM) servers (Total 4 Core). No changes will be made on the VM no. of Core (remain 4 core per server) the change will be on the SQL license ONLY.

    Friday, November 11, 2016 5:52 PM

Answers

  • Hello,

    if your SQL instance is clustered, you dont have to shut down instace. High availability soution like SQL Server Failover Cluster instance allows you upgrade SQL Seerver almost without downtime. Upgrade pasive nde first then failover and upgrade second server.

    You can find more details here

    https://blogs.technet.microsoft.com/meamcs/2012/05/14/sql-server-cluster-upgrade-tips-for-minmizing-upgrade-downtime-and-using-rolling-upgrade/

    • Marked as answer by Raid_ABD Sunday, November 13, 2016 8:17 AM
    Friday, November 11, 2016 10:28 PM
  • Follow the upgrade guide for upgrading from SQL 2008 to SQL 2014.

    http://msdn.microsoft.com/en-us/library/ms191295(v=sql.120).aspx

    You start on the passive node, do the upgrade, then failover and then upgrade the  formerly active node, now passive node.

    Pay attention to the notes here:

    https://msdn.microsoft.com/en-us/library/ms191295(v=sql.120).aspx#Anchor_4

    As Hermesss points out - there is no need to shut down both the nodes simultaneously.

    • Marked as answer by Raid_ABD Sunday, November 13, 2016 8:18 AM
    Saturday, November 12, 2016 1:36 AM

All replies

  • Hello,

    if your SQL instance is clustered, you dont have to shut down instace. High availability soution like SQL Server Failover Cluster instance allows you upgrade SQL Seerver almost without downtime. Upgrade pasive nde first then failover and upgrade second server.

    You can find more details here

    https://blogs.technet.microsoft.com/meamcs/2012/05/14/sql-server-cluster-upgrade-tips-for-minmizing-upgrade-downtime-and-using-rolling-upgrade/

    • Marked as answer by Raid_ABD Sunday, November 13, 2016 8:17 AM
    Friday, November 11, 2016 10:28 PM
  • Follow the upgrade guide for upgrading from SQL 2008 to SQL 2014.

    http://msdn.microsoft.com/en-us/library/ms191295(v=sql.120).aspx

    You start on the passive node, do the upgrade, then failover and then upgrade the  formerly active node, now passive node.

    Pay attention to the notes here:

    https://msdn.microsoft.com/en-us/library/ms191295(v=sql.120).aspx#Anchor_4

    As Hermesss points out - there is no need to shut down both the nodes simultaneously.

    • Marked as answer by Raid_ABD Sunday, November 13, 2016 8:18 AM
    Saturday, November 12, 2016 1:36 AM
  • Thanks Hermess
    Sunday, November 13, 2016 8:18 AM
  • Thanks Hilary
    Sunday, November 13, 2016 8:18 AM
  • Hello Everyone I went through the Upgrade path, and downloaded the excel sheet and I got the following by comparing the current build version (10.0.4000.0): ------------ 10.00.4000.00 2285068 29-Sep-2010 SP2 RTW / PCU 2 N/A Service Pack No, update to 10.00.6535.00 (MS15-058, KB 3045308) Extended Support Phase 9-Oct-2012 ------------ In addition, I was wrong about the OS version, it is windows server 2008 R2 64-bit Enterprise Edition and not standard Edition. So, it seems that I need to install SQL SP3 first to be SQL 2008 Sp3 to be able to upgrade. Please advise. Best Regards Raid
    Sunday, November 13, 2016 9:35 AM
  • The standard edition does support clustering and Always on, you can also install the Enterprise Edition of SQL Server on the Standard Edition of the OS, although apparently this is not something you wish to do.

    Update the service pack and you should be good.

    It further sounds like you are correct - that you need to apply sp3 before the upgrade:

    https://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

    The rest of the steps still apply.

    Did you check the hardware requirements here?

    https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.120%29.aspx?f=255&MSPPError=-2147217396

    Sunday, November 13, 2016 11:53 AM
  • Hello Hilary

    The existing hardware is:

    Hyper-V VM machine

    24 GB of Ram

    4 CPU

    Free Space of 120 GB vhd (local drive)

    Backup, logs and datafiles are located at storage (space available).

    Best Regards

    Tuesday, November 15, 2016 10:26 AM