dbTalk Databases Forums  

How to upgrade to SP2 on active/active

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering How to upgrade to SP2 on active/active

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


Discuss How to upgrade to SP2 on active/active in the microsoft.public.sqlserver.clustering forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Anthony Thomas
 
Posts: n/a

Default Re: How to upgrade to SP2 on active/active - 04-27-2008 , 02:21 PM





SS2K5 RTM had a bug in that the tools were not deployed to all cluster
nodes, only the node from which the installation was launched. One ended up
having to go to each cluster node and modify the configuration by adding the
tools through the Add/Remove Software utility.

However, starting with SP1 and later, this bug was fixed in that the patches
and hotfixes will correctly update the tools on every node where they had
been successfully deployed.

Sincerely,


Anthony Thomas, MCDBA, MCSA
Senior Consultant
Sogeti USA


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Quote:
Once you've applied the SP to a DBMS on a cluster, you don't have to
reapply
it to the other nodes. However, for the tools, you do.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"MLavoie" <MLavoie (AT) discussions (DOT) microsoft.com> wrote in message
news:22729CC4-1D7D-45FF-B266-E05796212CA3 (AT) microsoft (DOT) com...
Hi,

I need a simple procedure to upgrade our SQL2005 active/active cluster.
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



Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top