| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2009-02-11 : 16:24:24
|
| Environment:MSCS Cluster - 2 server with windows server 2003 Ent. Edition - sp2sql server 2000 enterprise edition - sp4We need to rebuild our cluster, don't ask me why because it's a long story....We have a third server available and we would like to install a third node for the cluster, install SQL Server 2000 on it and then rebuild the old nodes, one node at a time.I am searching for a white paper, instruction, step by step procedure and so on.On the actual cluster there is only one instance installed which is hosted by node1.Could you please point me in the right direction?Thank you very much for your time and support.Kind regards.Franco |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-02-11 : 18:20:26
|
| Does the third server have the exact hardware specs as the othe two? It is very important for the stability of the cluster that everything be the same.I don't have any whitepapers to show you on what to do, but I know for sure that you'll need to run SQL Server setup in order to failover the SQL instances to the third node. SQL Server setup will have to be run for each of the instances installed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2009-02-12 : 02:16:15
|
| Tara thank you for your reply.Yes, the hardware is the same for all the nodes.My concern was also about the data and log files that are stored on a SAN, let's say disk v:\ and w:\ and how to manage the setup for maintain the failover cluster.Kind regards.Franco |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-02-12 : 10:20:57
|
| The data and log files are "clustered" and whether you have 2 nodes or 4.. only one of them owns the instance at a time.. usually your windows team does the cluster installation and the DBA team does SQL installation. Additional nodes mean additional IP's and disk resources..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2009-02-12 : 11:06:00
|
| Yes I know...but I was asking for a procedure.How can I install SQL Server on a third node of an existing sql server cluster?Franco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2009-02-12 : 15:09:18
|
| Tara, thank you again for your reply.I have found this note:http://technet.microsoft.com/en-us/library/cc917693.aspx#EGAA"Adding or Removing a Cluster Node from the Virtual Server DefinitionAnother new feature of SQL Server 2000 failover clustering is the ability to add or remove a cluster node from a SQL Server virtual server definition. Adding nodes to the existing SQL Server virtual server definition performs all the necessary operations on the new nodes (including installing binaries, system components, and creating services) and performs the necessary modifications to the cluster configuration."Does this mean that, after the configuration of the third node in the cluster, from the new node, launch sql server setup, and that's it?If it is like this....what can I say, great!But..what about SP4 and cumulative hotfix already installed on other 2 nodes?Am i missing something?Franco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2009-02-12 : 16:16:13
|
| great.thanks a lot.Franco |
|
|
|
|
add a third node on a cluster