Upgrading Microsoft SQL 2005 to 2005 SP1 in a SFW HA cluster environment
| Article:HOWTO65980 | | | Created: 2012-01-25 | | | Updated: 2012-01-27 | | | Article URL http://www.symantec.com/docs/HOWTO65980 |
To install Microsoft SQL 2005 Server SP1
From the Cluster Explorer, right-click the SQL Server service group and select Offline on all nodes.
On the node where the SQL Server service group was taken offline, online the SQL 2005 resource for the shared drive containing the SQL databases.
From the Cluster Explorer, right-click the SQL Server service group which is now partially online, and select Freeze >Persistent.
If a VVR RVG service group is present, verify that it is online on the node where Microsoft SQL 2005 Service Pack 1 is to be installed.
Install Microsoft SQL 2005 Service Pack 1 on the active node (where the SQL Server service group is online), using the instructions provided by Microsoft.
Repeat step 5 for each additional SQL instance in this service group, if you have more than one instance in this service group.
From the Cluster Explorer, right-click the SQL Server service group which is still online and select Unfreeze.
From the Cluster Explorer, right-click the SQL Server service group and select Offline on the node where it was online.
On the failover node, online the SQL 2005 resource for the shared drive containing the SQL databases.
From the Cluster Explorer, right-click the SQL Server service group which is now partially online and select Freeze >Persistent.
Install Microsoft SQL 2005 Service Pack 1 on the active node (where the SQL Server service group is online), using the instructions provided by Microsoft SQL Server 2005 Service Pack 1 Setup.
Repeat step 11 for each additional SQL instance in this service group, if you have more than one instance in this service group.
From the Cluster Explorer, right-click the SQL Server service group which is still online and select Unfreeze
From the Cluster Explorer, right-click the SQL Server service group and select Offline on the node where it was online
Optionally reboot and online each service group to verify the database connect for each node.
Repeat step 9 through step 15 on each additional node if more than two SQL 2005 nodes are in use.
For a Disaster Recovery environment, repeat this procedure at the secondary site.
When Microsoft SQL 2005 Server Service Pack 1 has been completely installed on all nodes, test user connectivity to the instances.
Test the SQL Server service group by bringing it online and failing it over from node to node. When testing is complete, the upgrade is complete.
If more than one SQL Server service group is present, repeat this entire procedure for each SQL Server service group.
|
|
Legacy ID
v55396915_v66483192
Article URL http://www.symantec.com/docs/HOWTO65980
Terms of use for this information are found in Legal Notices
Thank you.