To upgrade SQL Server on the additional nodes

1. Bring the storage resources online.

   From the VCS Cluster Manager (Java Console), right-click each resource and select Online. Click Yes in the confirmation pop-up box to bring the resource online.

2. Rename the existing SQL Server data directories on the shared disks. These directories are updated when SQL Server is installed on the first node. You may also delete these directories.
3. Copy the backed-up SQL Server data directories from the temporary location to the shared disks.

   These directories are the same ones that you had backed up earlier while upgrading SQL Server on the first cluster node.

4. Launch the Microsoft SQL Server installer for the appropriate version to install the application on the node. Select the option to upgrade the existing SQL Server instances, when prompted to do so. The installer then automatically places the SQL Server data files at the appropriate location.

   Refer to the Microsoft SQL Server documentation for instructions.

5. Take the entire service group offline on the node.

   Note:

   If there are no additional nodes for upgrade, you need not take the service group offline.

   The upgrade steps on the additional cluster node are now complete. Delete the existing SQL Server service group and proceed to create the service group for the upgraded SQL Server version in the cluster.