Veritas InfoScale™ 7.4.1 Installation and Upgrade Guide - Windows
- Preinstallation and planning
- About InfoScale licenses
- 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 Oracle
- Upgrading application service packs in an InfoScale environment
- Appendix A. Services and ports
- Appendix B. Migrating from a third-party multi-pathing solution to DMP
Upgrading to later versions of SQL Server
This section describes how to upgrade the following application versions in an InfoScale environment:
SQL Server 2008 or 2008 R2 to SQL Server 2012
If SQL Server 2008 or 2008 R2 is configured in an InfoScale environment, you cannot directly upgrade to a version later than SQL Server 2012. You must first upgrade to SQL Server 2012 and then upgrade to later supported version.
SQL Server 2012 or later to a currently supported version
Perform the following tasks before you begin the upgrade:
Take a backup of the SQL databases.
In case of a disaster recovery (DR) configuration:
Ensure that the databases on the primary site and the secondary site are synchronized and then stop the replication between the sites.
Make a note of the SQL virtual server name and all the IP addresses configured at the primary site and the secondary site. These details are needed later.
At a high level, the upgrade process involves the following tasks:
Upgrade SQL Server on the first cluster node.
Upgrade SQL Server on each additional failover node.
In a DR configuration, repeat the upgrade procedures on the nodes at the secondary site. First upgrade SQL Server on the first cluster node at the DR site, and then upgrade the application on the additional failover nodes.
Delete the existing SQL Server service group, including the service group at the DR site, if applicable.
Create a service group for the upgraded SQL Server version, using the SQL Server Configuration Wizard. In case of a DR setup, create a service group at the secondary site too.
Note:
In a DR configuration, first upgrade SQL Server on the cluster nodes at the primary site and then proceed with the nodes at the secondary site. You must follow the same upgrade sequence at both sites - upgrade the first node and then the additional nodes - as described in this section.