Saturday, January 20, 2007

Service Pack / Hotfix on SQL clusters

Guidelines for a smooth install of a Service Pack or Hotfix on a clustered SQL environment >

1 Install SP on first node
2 Failover active cluster groups to second node (Cluster Administrator)
3 Restart first node

(await restart of first node)

4 Install SP on second node
5 Failover active cluster groups to first node
6 Restart second node

(await restart of second node)

7 Test failing over of each group, leaving them back on original nodes.

No comments: