all groups > sql server clustering > february 2006 >
You're in the

sql server clustering

group:

adding a new sql server node to an existing sql cluster


adding a new sql server node to an existing sql cluster Stephan
2/27/2006 7:19:27 AM
sql server clustering:
I currently have a single node SQL 2000 cluster running on 2003 Server. I now
want to add the second node, but want to make sure I fully understand the
process. I run the SQL setup from the new node and select the advanced option
for failover clustering. It all seems very straight forward, but I want to be
sure. Does this cause the clustered SQL instance to be restarted, or is there
no outage?

Re: adding a new sql server node to an existing sql cluster Tom Moreau
2/27/2006 11:54:10 AM
The cluster won't restart when you add a new node. Be sure to add the SQL
service pack to the new node while the *OLD* node owns the SQL Server
resource. This will simply add the binaries to the new node without
interrupting SQL. If you need to add a hotfix, however, you'll have to do
that on the mode that owns SQL Server. Therefore, you'll have to failover
to the new node and add the hotfix from there.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
I currently have a single node SQL 2000 cluster running on 2003 Server. I
now
want to add the second node, but want to make sure I fully understand the
process. I run the SQL setup from the new node and select the advanced
option
for failover clustering. It all seems very straight forward, but I want to
be
sure. Does this cause the clustered SQL instance to be restarted, or is
there
no outage?

Any help confirming this would be appreciated.
Re: adding a new sql server node to an existing sql cluster Stephan
2/27/2006 12:41:22 PM
Thanks, Tom, that's what I thought.

[quoted text, click to view]
AddThis Social Bookmark Button