Perform the following tasks to delete the existing service group and create one for the newer application version

1. For the SQL Server 2008 instance you want to upgrade, take the service group offline and delete it. Use the VCS Cluster Manager (Java Console). Perform this step on the primary site and the secondary site.

2. Stop the replication between the primary site and the secondary site.

3. For the selected instance, mount the created volumes and LUNs on any one of the cluster node, on both the sites.

   Note:

   Ensure that the instance name and ID is the same on all the cluster nodes.

4. Launch the SQL Server installer for 2008 R2 to install the application on the node. Select the option to upgrade the existing SQL Server instances when prompted to do so.

5. To upgrade the additional nodes, dismount the volumes from the upgraded node and mount them on the node that is yet to be upgraded. Launch the installer to install SQL Server 2008 R2.

   Repeat this task for each additional node.

6. Create the SQL Server service group, reconfigure the disaster recovery (DR) components, and then set the required resource dependency.

   For details, refer to the application-specific solutions guide.