The "Veritas Storage Foundation™ and High Availability Solutions Installation and Upgrade Guide Windows Server 2003, Windows Server 2008 5.1 SP1" document appears to give conflicting directions when upgrading both the SFWHA and SQL Server :
If you plan to upgrade both Microsoft SQL Server and SFW HA, first upgrade Microsoft SQL Server, and then follow with the upgrade to SFW HA 5.1. For additional information:
■ See “Upgrading from Microsoft SQL Server 2000 to SQL Server 2005” on page 226.
■ See “Upgrading from Microsoft SQL Server 2000/2005 to Microsoft SQL Server 2008” on page 228
Ensure that you do the following before proceeding with the upgrade tasks:
■ Take a backup of the SQL databases.
■ In case of a Disaster Recovery environment, ensure that the databases at the primary and secondary sites are synchronized.
■ Ensure that you have installed SFW HA 5.1 Application Pack 1 for Windows and the VCS database agents for SQL 2008, on all the SQL service group cluster nodes that you want to upgrade.
So... How can you upgrade SQL before upgrading to SFW HA5.1 and yet install the SFW HA5.1 Application Pack 1 before upgrading SQL?
Our plan calls for upgrading SFW HA from 4.3MP1 to 4.3MP2 then to 5.1SP1a with AP1, after which we will upgrade SQL server from 2000 to 2008 R2, possibly a week later.
Solved! Go to Solution.