Re: Proper procedure for adding a 3rd node to a SQL 2005/MSCS cluster



Existing node. Add-remove programs. SQL 2005.

With SQL 2000 you had to re-run the installer to change the cluster
configuration. With SQL 2005, you do cluster maintenance with add-remove
programs under control panel.

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




<drew.flint@xxxxxxxxx> wrote in message
news:1140025669.304063.30830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Right now I have a failover cluster running Windows 2003 Server
Enterprise Edition x64 and SQL Server 2005 Enterprise Edition x64. Each
node in the cluster is repsonsible for hosting a SQL Server instance.
Everything appears to be functioning correctly.
We are investigating adding a third node to provide us with N+1
failover capabilities. I have added the server into the MSCS cluster.
However, I'm stumped as far as how to get the SQL 2005 program files
installed without creating a new instance.
Could someone please advise what is the best method of adding a third
node to a cluster without having to create a third instance? Thanks in
advance,

Drew Flint
System Administrator
Plexus Systems



.



Relevant Pages

  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding 3 nodes to a cluster
    ... First you use the cluster admin tool to add the machines as nodes to the cluster. ... Then you run the SQL installer to install binaries on the newly added nodes and allow the new nodes to host the existing instances. ... >>>I need to add these new servers as seperate instances in the SQL ...
    (microsoft.public.sqlserver.clustering)