Veritas InfoScale 7.1 Installation and Upgrade Guide - Windows
- Preinstallation and planning
- Installing the Veritas InfoScale products
- Upgrading to InfoScale products
- Performing the post upgrade tasks
- Administering the InfoScale product installation
- Uninstalling the InfoScale products
- Performing application upgrades in an InfoScale environment
- Upgrading Microsoft SQL Server
- Upgrading SQL Server 2008 to SQL Server 2008 R2
- Upgrading to later versions of SQL Server
- Upgrading SQL Server 2008 to SQL Server 2008 R2
- Upgrading Oracle
- Upgrading application service packs in an InfoScale environment
- Upgrading Microsoft SQL Server
- Appendix A. Services and ports
- Appendix B. Migrating from a third-party multi-pathing solution to DMP
Upgrading SQL Server 2008 to SQL Server 2008 R2 on additional failover nodes
Perform the following steps on each additional failover node that is a part of the SQL Server service group.
To upgrade SQL Server on the additional nodes
- 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.
- Delete the original RegRep folder and rename the 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.
- Copy the backed-up SQL Server 2008 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.
- Freeze the SQL Server service group.
From the VCS Cluster Manager, right-click the SQL Server service group in the tree view in the left pane and click Freeze > Persistent.
- Launch the SQL Server installer for 2008 R2 installer 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.
- From the VCS Cluster Manager, right-click the SQL Server service group in the tree view in the left pane and click Unfreeze.
- 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. Proceed to modify the SQL Server SQL Server service group configuration.