Upgrade a SQL Server Failover Cluster

SQL Server supports upgrade of the Database Engine and Analysis Services from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 failover clusters separately on all failover cluster nodes.

Support details are as follows:

  • Upgrade is supported both through the user interface and from the command prompt. For more information, see Upgrade a SQL Server Failover Cluster Instance (Setup) and Install SQL Server 2012 from the Command Prompt.

  • Upgrading from SQL Server 2008 R2 — You can run upgrade from the command prompt on each failover cluster node, or by using the Setup UI to upgrade each cluster node. If Full-text search and Replication features do not exist on the instance being upgraded, they will be installed automatically with no option to omit them.

  • Service pack installation - you must apply SQL Server service packs and patches to SQL Server 2012 failover clusters separately on all nodes.

  • The following scenarios are not supported in SQL Server 2012:

    • You cannot migrate from a stand-alone instance of SQL Server to a SQL Server 2012 failover cluster.

    • Add features to a SQL Server 2012 failover cluster. For example, you cannot add the Database Engine to an existing Analysis Services-only failover cluster.

    • You cannot downgrade a SQL Server 2012 failover cluster node to a stand-alone instance of SQL Server 2012.

  • For more information, see AlwaysOn Failover Cluster Instances (SQL Server).

Upgrading a SQL Server Multi-Subnet Failover Cluster

You cannot directly upgrade a non–multi-subnet SQL Server failover cluster to a SQL Server multi-subnet failover cluster. For more information, see Upgrade a SQL Server Failover Cluster Instance (Setup).

See Also

Tasks

Upgrade a SQL Server Failover Cluster Instance (Setup)

Reference

Supported Version and Edition Upgrades

Concepts

Install SQL Server 2012 from the Command Prompt