dbTalk Databases Forums  

Breaking a Sql Cluster

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


Discuss Breaking a Sql Cluster in the microsoft.public.sqlserver.clustering forum.



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

Default Breaking a Sql Cluster - 03-03-2008 , 12:56 PM






We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?

Reply With Quote
  #2  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM






A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #3  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #4  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #5  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #6  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #7  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #8  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #9  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



Reply With Quote
  #10  
Old   
Tom Moreau
 
Posts: n/a

Default Re: Breaking a Sql Cluster - 03-03-2008 , 01:39 PM



A cluster can run with even one node. What you are planning is quite
feasible. What are your plans once you have the DB's on the stand-alone?
Keep in mind that on a stand-alone server, you lose the high availability
that you once had.

--
Tom

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


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

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our
databases
might not be compatible with SQL 2005. Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?



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.