Upgrading to later versions of SQL Server


Upgrading to later versions of SQL Server
Prev	Upgrading Microsoft SQL Server	Next

This section describes how to upgrade the following application versions in an InfoScale environment:

SQL Server 2008 or 2008 R2 to SQL Server 2012
SQL Server 2012 to SQL Server 2014

Perform the following tasks before you begin the upgrade:

Take a backup of the SQL databases.
In case of a disaster recovery (DR) configuration:
- Ensure that the databases on the primary site and the secondary site are synchronized and then stop the replication between the sites.
- Make a note of the SQL virtual server name and all the IP addresses configured at the primary site and the secondary site. These details are needed later.

At a high level, the upgrade process involves the following tasks:

Upgrade SQL Server on the first cluster node.
Upgrade SQL Server on each additional failover node.
In a DR configuration, repeat the upgrade procedures on the nodes at the secondary site. First upgrade SQL Server on the first cluster node at the DR site, and then upgrade the application on the additional failover nodes.
Delete the existing SQL Server service group, including the service group at the DR site, if applicable.
Create a service group for the upgraded SQL Server version, using the SQL Server Configuration Wizard. In case of a DR setup, create a service group at the secondary site too.

Note:

In a DR configuration, first upgrade SQL Server on the cluster nodes at the primary site and then proceed with the nodes at the secondary site. You must follow the same upgrade sequence at both sites - upgrade the first node and then the additional nodes - as described in this section.

Prev	Up	Next
Deleting the SQL Server 2008 service group and creating the SQL Server 2008 R2 service group	Home	Upgrading SQL Server on the first cluster node