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 or 2008 R2 to a service pack
Use this procedure to perform the following upgrades:
SQL Server 2008 to SQL Server 2008 SP1, SQL Server 2008 SP2, or SQL Server 2008 SP3.
SQL Server 2008 R2 to SQL Server 2008 R2 SP1
Consider the following points before you proceed with the upgrade
You must have administrative privileges to the SQL instance that you want to upgrade.
Make sure that you have a recent backup of your system and user databases.
Refer to the Microsoft documentation for prerequisites related to SQL Server 2008 Service Pack installation.
Consider a two node cluster, Node A and Node B. The SQL service group is ONLINE on Node A, and Node B is the passive node.
You can upgrade SQL Server in any of the following ways:
Upgrade SQL Server on all the nodes parallely
See “To parallely upgrade SQL Server on all the cluster nodes”.
Upgrade SQL Server on the passive node first and then upgrade the active nodes
Use the following procedure to parallely upgrade SQL Server on all the cluster nodes.
To parallely upgrade SQL Server on all the cluster nodes
- Freeze (persistent) the service group on Node A (active node).
- Upgrade the SQL 2008 instance on Node A and Node B.
- Reboot the nodes.
- Unfreeze the service group on Node A, if it is still frozen.
Use the following procedure to upgrade SQL Server on the passive node first and subsequently on the active node.
To upgrade SQL Server on the passive nodes first
- Freeze the service group on Node A (active node).
- Confirm all SQL services are stopped on Node B.
- Upgrade the SQL Server 2008 instance on Node B.
- Reboot node B.
- Unfreeze the service group on node A.
- Fail over the service group to Node B.
- After the service group comes online, freeze the service group on Node B.
- Confirm all SQL services are stopped on Node A.
- Upgrade the SQL Server 2008 instance on Node A.
- Reboot Node A.
- Unfreeze the service group on node B.
- Fail back the service group to Node A.