Veritas InfoScale 7.1 Installation and Upgrade Guide - Windows
- Preinstallation and planning
- Installing the Veritas InfoScale products
- About installing the InfoScale products
- About the co-existence of InfoScale products
- Installing the server components using the installation wizard
- Applying the selected installation and product options to multiple systems
- Installing the server components using the command-line installer
- Parameters for Setup.exe
- Available product options and supported DMP DSMs
- Registering the InfoScale Storage resource DLLs
- Installing the client components
- Upgrading to InfoScale products
- Performing the post upgrade tasks
- Deployment scenarios and applicable post upgrade tasks
- Re-enabling Volume Replicator in a non-clustered environment
- Re-enabling Volume Replicator in a Microsoft failover cluster environment
- Reconnecting DMP DSM paths after the upgrade
- Reconfiguring the Veritas InfoScale Messaging Service
- Importing the configured rules
- Upgrading the dynamic disk group version
- Upgrading clusters for stronger security
- Reinstalling the custom agents
- Including custom resources
- 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
- Preupgrade tasks for upgrading SQL Server 2008 to SQL Server 2008 R2 in a disaster recovery environment
- Upgrading SQL Server 2008 to SQL Server 2008 R2 on the first cluster node
- Upgrading SQL Server 2008 to SQL Server 2008 R2 on additional failover nodes
- Modifying the SQL Server 2008 service group configuration
- Deleting the SQL Server 2008 service group and creating the SQL Server 2008 R2 service group
- 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
This section describes how to upgrade SQL Server 2008 to SQL Server 2008 R2 in an InfoScale environment. Complete these tasks on all the cluster nodes that are part of the SQL Server service group, one node at a time.
At a high level, the upgrade process involves the following tasks:
Take a backup of the SQL Server databases.
Upgrade SQL Server on the first cluster node.
Upgrade SQL Server on each additional failover node.
In case of a disaster recovery (DR) configuration, ensure that the databases on the primary site and secondary site are synchronized and then proceed to upgrade the cluster.
You can upgrade the cluster using one of the following methods:
Add a temporary disk and create the volumes similar to that on the primary site.
To follow this method, perform the pre-upgrade tasks and then proceed to upgrade the cluster on both the sites. You must follow the same upgrade sequence simultaneously at both the sites. Upgrade the first node and then upgrade the additional nodes.
Delete the SQL Server 2008 service group and then create the SQL Server 2008 R2 service group.
Follow this method only if the data size is small. After you re-create the service groups and setup replication across the two sites, the entire data will be replicated. The replication takes a considerable amount of time.
See Deleting the SQL Server 2008 service group and creating the SQL Server 2008 R2 service group.
Run the SQL Server configuration wizard in the modify mode to modify the SQL Server 2008 service group.