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 the first cluster node
This procedure assumes that a single SQL Server instance is configured in a multi-node cluster.
To upgrade SQL Server on the first cluster node
- On the node where the application service group is online, take only the SQL Server resources offline.
From the VCS Cluster Manager (Java Console), right-click the resource and select Offline. Click Yes in the confirmation pop-up box to take the resource offline.
- Take a backup of the SQL Server 2008 directories from the shared disk and store them at a temporary location.
The backed-up directories are needed later, while you upgrade SQL Server on the additional failover nodes.
- Delete the RegRep resource.
- 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 to install the application on the node. Select the option to upgrade the existing SQL Server instances when prompted to do so. Also, ensure that the instance name or ID is the same on all the cluster nodes. The SQL Server installer then automatically places the SQL Server data files in the appropriate location.
Refer to the Microsoft SQL Server documentation for instructions.
- Unfreeze and then take the SQL Server service group offline.
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.
The upgrade steps on the first cluster node are now complete. Proceed to upgrading SQL Server on the additional failover nodes.