Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

upgrading cluster hardware

 
   Database Forums (Home) -> Clustering RSS
Next:  Can't open a database created with a previous ver..  
Author Message
Volker Schmid

External


Since: Sep 21, 2005
Posts: 2



(Msg. 1) Posted: Wed Sep 21, 2005 4:55 am
Post subject: upgrading cluster hardware
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hi group,

We have a two node windows 2000 sp4 cluster running SQL 2000 SP3 in
active/active mode.
We just want to upgrade the hardware now, what is the easiest way? Can you
remove one physical node while all sql instances are on the other one. Then
take the new hardware, add it to the cluster and move the cluster groups to
the new node, doing the same with the other node then.

Is there a white paper from Microsoft saying this is supported or are there
any documents describing that step by step.

Thanks for the help

Volker

 >> Stay informed about: upgrading cluster hardware 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(Msg. 2) Posted: Wed Sep 21, 2005 7:00 am
Post subject: Re: upgrading cluster hardware [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

That's pretty much the process. It's known as a rolling upgrade. Just move
the groups to one node, remove the other node and then add the other node,
following the procedure in the BOL. You'll have to add the SP to the new
node. In that case, add the SP to the new node, while the groups are on the
*other* node. However, for any hotfixes, you will have to run those from
the new node while the groups are running on the *new* node.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Volker Schmid" wrote in message

Hi group,

We have a two node windows 2000 sp4 cluster running SQL 2000 SP3 in
active/active mode.
We just want to upgrade the hardware now, what is the easiest way? Can you
remove one physical node while all sql instances are on the other one. Then
take the new hardware, add it to the cluster and move the cluster groups to
the new node, doing the same with the other node then.

Is there a white paper from Microsoft saying this is supported or are there
any documents describing that step by step.

Thanks for the help

Volker

 >> Stay informed about: upgrading cluster hardware 
Back to top
Login to vote
Volker Schmid

External


Since: Sep 21, 2005
Posts: 2



(Msg. 3) Posted: Wed Sep 21, 2005 9:55 am
Post subject: Re: upgrading cluster hardware [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Tom,

thanks for your help. The BOL documentation was what I needed. What do you
mean with "...add the SP to the new node"?
Do I have to install the service pack again?

Regards
Volker



"Tom Moreau" wrote in message

> That's pretty much the process. It's known as a rolling upgrade. Just
> move
> the groups to one node, remove the other node and then add the other node,
> following the procedure in the BOL. You'll have to add the SP to the new
> node. In that case, add the SP to the new node, while the groups are on
> the
> *other* node. However, for any hotfixes, you will have to run those from
> the new node while the groups are running on the *new* node.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Volker Schmid" wrote in message
>
> Hi group,
>
> We have a two node windows 2000 sp4 cluster running SQL 2000 SP3 in
> active/active mode.
> We just want to upgrade the hardware now, what is the easiest way? Can you
> remove one physical node while all sql instances are on the other one.
> Then
> take the new hardware, add it to the cluster and move the cluster groups
> to
> the new node, doing the same with the other node then.
>
> Is there a white paper from Microsoft saying this is supported or are
> there
> any documents describing that step by step.
>
> Thanks for the help
>
> Volker
>
>
 >> Stay informed about: upgrading cluster hardware 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Mar 15, 2005
Posts: 76



(Msg. 4) Posted: Wed Sep 21, 2005 9:55 am
Post subject: Re: upgrading cluster hardware [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes. The install process puts RTM binaries on the new node. Those have to
be updated with any service packs or hotfixes you ran. You will also have
to install the service pack and hotfixes for each instance, just like you
did before.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Volker Schmid" wrote in message

> Hi Tom,
>
> thanks for your help. The BOL documentation was what I needed. What do you
> mean with "...add the SP to the new node"?
> Do I have to install the service pack again?
>
> Regards
> Volker
>
>
>
> "Tom Moreau" wrote in message
>
>> That's pretty much the process. It's known as a rolling upgrade. Just
>> move
>> the groups to one node, remove the other node and then add the other
>> node,
>> following the procedure in the BOL. You'll have to add the SP to the new
>> node. In that case, add the SP to the new node, while the groups are on
>> the
>> *other* node. However, for any hotfixes, you will have to run those from
>> the new node while the groups are running on the *new* node.
>>
>> --
>> Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .
>> "Volker Schmid" wrote in message
>>
>> Hi group,
>>
>> We have a two node windows 2000 sp4 cluster running SQL 2000 SP3 in
>> active/active mode.
>> We just want to upgrade the hardware now, what is the easiest way? Can
>> you
>> remove one physical node while all sql instances are on the other one.
>> Then
>> take the new hardware, add it to the cluster and move the cluster groups
>> to
>> the new node, doing the same with the other node then.
>>
>> Is there a white paper from Microsoft saying this is supported or are
>> there
>> any documents describing that step by step.
>>
>> Thanks for the help
>>
>> Volker
>>
>>
>
>
 >> Stay informed about: upgrading cluster hardware 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Upgrading the cluster Hardware - Hi I've a challenge of upgrading the curent cluster hardware. my current config: node1 and node2 with a vs1\sql1 and vs2\sql2 respectively attached to SAN It's important to keep the same IP address and preferred the instance name because of my ERP..

Hardware recommendations for two node cluster - I am looking at putting the specs together for a new SQL Server 2005 cluster, two nodes. It needs to be capable of supporting multiple customer databases, around 20-30, average database size is 3GB but several will be in the region of 10-20GB, capable...

Replace hardware in a SQL2000 2 node cluster - I am currently running a 2-node (Active/Passive) SQL 2000 cluster on 2 Windows 2003 machines. Both machines are Dell PE4400 with a PERC3/DC card in each one that attaches to a Dell PowerVault 221 (this is where all databases/logs are kept). Since..

Upgrading Windows 2000 cluster to Windows 2003 Cluster. - I am planning to upgrade from Windows 2000 to a Windows 2003 Cluster. I have SQL server 2000 which we installed it as a virtual server. We are doing a rolling upgrade and want to introduce new hardware at the same time. Is it possible/recommended? O...

Need advice on hardware for SQL 2005 - Hello, I would appreciate if someone can give some advice on hardware for building up SQL 2005 cluster. We will have 4 database of 50 GB each. How many processors, memory,... do I need? My preference is to go for HP servers Thanks in advance
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]