locked
Migrate/upgrade SQL Server 2008 cluster to SQL Server 2014 cluster? RRS feed

  • Question

  • Hello recently I completed installing a SQL 2008 cluster 64 bit EE (Active-Passive) on Windows 2008 r2 64 bit EE which current has zero user DBs on there in being a fresh install. We recently acquired SQL 2014 64 EE installation (licenses) and would like to have this DB cluster to become SQL 2014 cluster (Active-Passive). What is the recommended way in doing this...in place upgrade on Passive node first, fail-over, & then upgrade other node...or uninstall SQL 2008 on both nodes completely & then install SQL 2014 cluster?

    Thanks in advance.

    Thursday, July 16, 2015 6:46 PM

Answers

  • Hello,

    You can perform a rolling upgrade as explained on the following article:

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

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, July 16, 2015 7:21 PM
  • Thanks for your reply Alberto, much appreciated.

    The targeted DBs are from a SQL Server 2005 cluster which will upgrading this cluster to SQL 2014 be compatible to run the SQL 2005 DBs?

    Yes it will be compatible . But please first test it. I mean to say 2014 has new cardinality estimator which differently while creating query plan and query which might be executing in less time in 2005 may start taking  time in 2014.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Friday, July 17, 2015 5:13 AM

All replies

  • Hello,

    You can perform a rolling upgrade as explained on the following article:

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

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, July 16, 2015 7:21 PM
  • Thanks for your reply Alberto, much appreciated.

    The targeted DBs are from a SQL Server 2005 cluster which will upgrading this cluster to SQL 2014 be compatible to run the SQL 2005 DBs?

    Thursday, July 16, 2015 9:12 PM
  • Thanks for your reply Alberto, much appreciated.

    The targeted DBs are from a SQL Server 2005 cluster which will upgrading this cluster to SQL 2014 be compatible to run the SQL 2005 DBs?

    Yes it will be compatible . But please first test it. I mean to say 2014 has new cardinality estimator which differently while creating query plan and query which might be executing in less time in 2005 may start taking  time in 2014.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Friday, July 17, 2015 5:13 AM