SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SP4 installation on active/passive cluster


SP4 installation on active/passive cluster

Author
Message
inevercheckthis2002
inevercheckthis2002
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 474
I am going to be installing SP4 on SQL Server 2005 installed on a Windows 2003 R2 Active/Passive cluster (production). I do not have a 'test' cluster.

I have researched this a bit, and it seems that you just install the service pack on the active node.

Some of my searches have mentioned a server restart. I'm not sure if one is required on a clustered server, or if a failover or two is necessary.

Can you recall if your SP4 install in a cluster required an outage?

Thanks!
Hakan Forsberg
Hakan Forsberg
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 317
You Will have to install the SP on all the potential nodes that could run your SQL instance as the local executables needs to be upgraded.
inevercheckthis2002
inevercheckthis2002
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 474
My understanding is that the service pack is installed on the active node - not 'each' node.

See Ken Davis post in this thread.

My question is whether a reboot is required when installing SQL Server 2005 SP4 in a cluster, or if a failover/failback does the trick.
Hakan Forsberg
Hakan Forsberg
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 317
Sorry, but the SP needs to be installed on both nodes. I would suggest the following:

1, Locate the "Passive" node (Node 2) and install the SP on it.

2, Failover from node 1 to node 2 and install the SP on node 1

3, (Optional) Fail back to node 1 after installing the SP if you want node 1 to be the preferred node.

Good luck!
inevercheckthis2002
inevercheckthis2002
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 474
I appreciate that you have responded.
Can you please supply a reference to your assertion?

Thanks!
Hakan Forsberg
Hakan Forsberg
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 317
Hi again,

When trying to refresh my memory I Think you are right. You don't need to run the installation from both nodes, but on both nodes. As long as you run the SP installation on the Active node, the SP installation will first upgrade the passive node and then the ative node.If the passive upgrade will fail (this you can check by checking the sql server version when failing over) there is a switch you can run with the sp installation...eg spxxxx.exe /passive. This switch will just install the SP on the passive node.

A node restart is not required, but a SQL service restart is required. But as Always, I would prefer to do the node restart as you can failover the instance during the restart.

I hope this was an answer to your question and I am really sorry for the missunderstanding from my side....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search