Upgrading SQL Server 2008 to SQL Server 2008 R2

This section describes how to upgrade SQL Server 2008 to SQL Server 2008 R2 in an InfoScale environment. Complete these tasks on all the cluster nodes that are part of the SQL Server service group, one node at a time.

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

  1. Take a backup of the SQL Server databases.

  2. Upgrade SQL Server on the first cluster node.

  3. Upgrade SQL Server on each additional failover node.

  4. In case of a disaster recovery (DR) configuration, ensure that the databases on the primary site and secondary site are synchronized and then proceed to upgrade the cluster.

    You can upgrade the cluster using one of the following methods:

  5. Run the SQL Server configuration wizard in the modify mode to modify the SQL Server 2008 service group.