Veritas InfoScale 7.0 Installation and Upgrade Guide - Windows
- Preinstallation and planning
- Installing the Infoscale products
- Installing the server components using the product installer
- Installing the server components using CLI
- Upgrading to InfoScale products
- Performing the post upgrade tasks
- Administering InfoScale product installation
- Uninstalling 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 3rd party multi-pathing solution to Dynamic Multi-pathing
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.