| Groups | Blog | Home |
sql server clustering : upgrade sql cluster hardware
I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go about this. I am running an active/active cluster on 2 ML370 servers. They are running Windows 2000 Advanced Server/SP2, MSSQL 2000 Enterprise/SP2. I want to know if all I have to do is Failover all resources from Server2 to Server1, then evict Server2? Then do all I have to do is run the cluster install? I am not sure what needs to be done with the SQL instance from Server2? Do I uninstall it or what? I hope this is clear enough. Any ideas please let me know. Jeff
Depends on what you need to upgrade,
if it's just cpu or memory or hardware that shouldn't impact the running of sqlserver, you don't have to reinstall sql or even evict the node. you can just move all the sql instances to one node (in off-peak time, assume one node can still support 2 instances), upgrade the idle node and rejoin it when the upgrade is done.
[quoted text, click to view] >-----Original Message----- impact the running of sqlserver, you don't have to >Depends on what you need to upgrade, >if it's just cpu or memory or hardware that shouldn't reinstall sql or even evict the node. you can just move all the sql instances to one node (in off-peak time, assume one node can still support 2 instances), upgrade the idle node and rejoin it when the upgrade is done. [quoted text, click to view] > Sorry for the misunderstanding. When I say upgrade, I mean >. > replace the physical box. I am pulling server2 out and
Been there, Done that.
You will need to follow the instructions in BOL on how to remove the SQL installation from a failed node. (Pretend one node failed and you are removing it). This is an extra step above the eviction from the cluster itself. Then follow the instructions again on installing SQL to a replacement node. Be sure and read the README file on the service pack installation to avoid causing downtime during the re-apply of a service pack. Repeat for the other node. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com [quoted text, click to view] "Jeff" <anonymous@discussions.microsoft.com> wrote in message news:6ec401c3e68d$1e2711c0$a601280a@phx.gbl... > I am in the planning process of upgrading the hardware on > our cluster. I need info/advice/suggestions on how to go > about this. > I am running an active/active cluster on 2 ML370 servers. > They are running Windows 2000 Advanced Server/SP2, MSSQL > 2000 Enterprise/SP2. > I want to know if all I have to do is Failover all > resources from Server2 to Server1, then evict Server2? > Then do all I have to do is run the cluster install? I am > not sure what needs to be done with the SQL instance from > Server2? Do I uninstall it or what? I hope this is clear > enough. Any ideas please let me know. > > Jeff >
Geoff, I dl and checked the SQLBOL. So to make sure I got this straight: 1. failover to server1 2. run sql setup and remove server2. (remove the named instance in setup) 3. evict node2 from cluster 4. build new server, install os, join cluster. 5. run sql setup on server1 and add server2 back to the failover cluster? Is this correct? Also, in doing step 5, does it copy the sql binaries onto server2 automatically? i am not worried about getting the server into the cluster the only part i am confused/worried about is the sql instance on server2. Is it a brand new install or does it retain the information from before? Any clarification you can provide would be appreciated. TIA, Jeff [quoted text, click to view] >-----Original Message-----
>Been there, Done that. > >You will need to follow the instructions in BOL on how to remove the SQL >installation from a failed node. (Pretend one node failed and you are >removing it). This is an extra step above the eviction from the cluster >itself. Then follow the instructions again on installing SQL to a >replacement node. Be sure and read the README file on the service pack >installation to avoid causing downtime during the re- apply of a service >pack. Repeat for the other node. > > >-- >Geoff N. Hiten >Microsoft SQL Server MVP >Senior Database Administrator >Careerbuilder.com > > >"Jeff" <anonymous@discussions.microsoft.com> wrote in message >news:6ec401c3e68d$1e2711c0$a601280a@phx.gbl... >> I am in the planning process of upgrading the hardware on >> our cluster. I need info/advice/suggestions on how to go >> about this. >> I am running an active/active cluster on 2 ML370 servers. >> They are running Windows 2000 Advanced Server/SP2, MSSQL >> 2000 Enterprise/SP2. >> I want to know if all I have to do is Failover all >> resources from Server2 to Server1, then evict Server2? >> Then do all I have to do is run the cluster install? I am >> not sure what needs to be done with the SQL instance from >> Server2? Do I uninstall it or what? I hope this is clear >> enough. Any ideas please let me know. >> >> Jeff >> > > >.
You are correct. Step 5 will install the Binaries on the new node. Don't
forget to run any service pack installs directly from te new node before you fail SQL over to it. That wil update the local binaries to the correct service pack level. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org [quoted text, click to view] <anonymous@discussions.microsoft.com> wrote in message news:6c3501c3e742$f7a96f00$a301280a@phx.gbl... > > Geoff, > > I dl and checked the SQLBOL. > So to make sure I got this straight: > > 1. failover to server1 > 2. run sql setup and remove server2. (remove the named > instance in setup) > 3. evict node2 from cluster > 4. build new server, install os, join cluster. > 5. run sql setup on server1 and add server2 back to the > failover cluster? > > Is this correct? Also, in doing step 5, does it copy the > sql binaries onto server2 automatically? > i am not worried about getting the server into the cluster > the only part i am confused/worried about is the sql > instance on server2. Is it a brand new install or does it > retain the information from before? > Any clarification you can provide would be appreciated. > > TIA, > > Jeff > > >-----Original Message----- > >Been there, Done that. > > > >You will need to follow the instructions in BOL on how to > remove the SQL > >installation from a failed node. (Pretend one node > failed and you are > >removing it). This is an extra step above the eviction > from the cluster > >itself. Then follow the instructions again on installing > SQL to a > >replacement node. Be sure and read the README file on > the service pack > >installation to avoid causing downtime during the re- > apply of a service > >pack. Repeat for the other node. > > > > > >-- > >Geoff N. Hiten > >Microsoft SQL Server MVP > >Senior Database Administrator > >Careerbuilder.com > > > > > >"Jeff" <anonymous@discussions.microsoft.com> wrote in > message > >news:6ec401c3e68d$1e2711c0$a601280a@phx.gbl... > >> I am in the planning process of upgrading the hardware > on > >> our cluster. I need info/advice/suggestions on how to go > >> about this. > >> I am running an active/active cluster on 2 ML370 > servers. > >> They are running Windows 2000 Advanced Server/SP2, MSSQL > >> 2000 Enterprise/SP2. > >> I want to know if all I have to do is Failover all > >> resources from Server2 to Server1, then evict Server2? > >> Then do all I have to do is run the cluster install? I > am > >> not sure what needs to be done with the SQL instance > from > >> Server2? Do I uninstall it or what? I hope this is clear > >> enough. Any ideas please let me know. > >> > >> Jeff > >> > > > > > >. > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |