dbTalk Databases Forums  

Install SP4 on Avtive/Passive Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Install SP4 on Avtive/Passive Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
RobinMC
 
Posts: n/a

Default Install SP4 on Avtive/Passive Cluster - 10-02-2009 , 09:01 AM






We have SQL 2000 Active/Passive cluster running on Windows 2003 SP1.
I need to apply SP4 but want to minimize downtime.
Would the following work?
remove the passive node from the cluster
apply SP4 to the server
add the server back to the cluster
failover to the server with the newly installed SP4
remove the other node (previously active, now passive node) from the cluster
apply SP4 to this server
add back to the cluster

Any help is greatly appreciated.
Thank you

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Install SP4 on Avtive/Passive Cluster - 10-02-2009 , 12:06 PM






That won't work.

Once you add the server to the cluster, you have to reinstall SQL and
repatch.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"RobinMC" <RobinMC (AT) discussions (DOT) microsoft.com> wrote

Quote:
We have SQL 2000 Active/Passive cluster running on Windows 2003 SP1.
I need to apply SP4 but want to minimize downtime.
Would the following work?
remove the passive node from the cluster
apply SP4 to the server
add the server back to the cluster
failover to the server with the newly installed SP4
remove the other node (previously active, now passive node) from the
cluster
apply SP4 to this server
add back to the cluster

Any help is greatly appreciated.
Thank you

Reply With Quote
  #3  
Old   
RobinMC
 
Posts: n/a

Default Re: Install SP4 on Avtive/Passive Cluster - 10-02-2009 , 12:49 PM



Thank you very much for your reply.

"Geoff N. Hiten" wrote:

Quote:
That won't work.

Once you add the server to the cluster, you have to reinstall SQL and
repatch.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"RobinMC" <RobinMC (AT) discussions (DOT) microsoft.com> wrote in message
news:0DAA09CA-F09D-4F2A-83E6-6D627A9C60A5 (AT) microsoft (DOT) com...
We have SQL 2000 Active/Passive cluster running on Windows 2003 SP1.
I need to apply SP4 but want to minimize downtime.
Would the following work?
remove the passive node from the cluster
apply SP4 to the server
add the server back to the cluster
failover to the server with the newly installed SP4
remove the other node (previously active, now passive node) from the
cluster
apply SP4 to this server
add back to the cluster

Any help is greatly appreciated.
Thank you


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.