Upgrading SQL Server 2008 or 2008 R2 with the latest service packs in a SFW HA cluster

Article:HOWTO65985  |  Created: 2012-01-25  |  Updated: 2012-01-26  |  Article URL http://www.symantec.com/docs/HOWTO65985
Article Type
How To


Environment

Subject


Upgrading SQL Server 2008 or 2008 R2 with the latest service packs in a SFW HA cluster

Product: SFW HA

Platform: Windows

Version: 6.0

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 to upgrade SQL Server 2008 or 2008 R2 with the latest service packs in a SFW HA environment:

  • 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.

  • Make sure that the SFW HA version installed is 5.1 SP2 or later.

  • 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:

Use the following procedure to parallely upgrade SQL Server on all the cluster nodes.

To parallely upgrade SQL Server on all the cluster nodes

  1. Freeze the service group on Node A (active node).

  2. Upgrade the SQL 2008 instance on Node A and Node B.

  3. Reboot the nodes, if it prompts for.

  4. Unfreeze the service group on Node A.

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

  1. Freeze the service group on Node A (active node).

  2. Confirm all SQL services are stopped on Node B.

  3. Upgrade the SQL Server 2008 instance on Node B.

  4. Reboot node B.

  5. Unfreeze the service group on node A.

  6. Fail over the service group to Node B.

  7. After the service group comes online, freeze the service group on Node B.

  8. Confirm all SQL services are stopped on Node A.

  9. Upgrade the SQL Server 2008 instance on Node A.

  10. Reboot Node A.

  11. Unfreeze the service group on node B.

  12. Fail back the service group to Node A.


Legacy ID



v55397313_v66483192


Article URL http://www.symantec.com/docs/HOWTO65985


Terms of use for this information are found in Legal Notices