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