Hi, I need a simple procedure to patch our SQL2005 active/active cluster to SP2. It's presently unpatched. From what I understand I need to do the following : 1- Failover node 2 ressources to node 1 2- Log on node 1 and install the SP2 on the two instances 3- Failover node 1 and node 2 ressources to node 2 4- Reboot node 1 5- Log on node 2 and install the SP2 on the two instances 6- Failover node 2 and node 1 ressources to node 1 7- Reboot node 2 8- Failover node 2 ressources to node 2 It seems too simple .... I'm I forgetting sometings ? Thanks
Just read the readme file.... http://download.microsoft.com/downl...7-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm
... good one but I'm so lost that I have read the readme and numerous other help files In my setup I have two instance by server, one active, one for failover. What I not sure, even after reading the readme, is the order that I need to follow. Like I said, I think I need to apply the SP2 on each server and on each instance but I 'm really not sure which is the best and fastest way to do that. Thanks anyway.
The section of the readme file to look at is 3.2.5. In my experience, the procedure is fairly simple. You just need to run the setup program for SP2 on your active node. The setup process will update both nodes for you at the same time (essentially). If you have a non-cluster-aware component installed on both nodes of your server, such as Integration Services, then you would also need to run SP2 on your passive node, and I think you can do that without having to move the cluster to that node. Then, you need to restart both nodes. I think that's it. Good luck! Steve
Check: http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm