SQL Server Performance

Remove Failed Node

Discussion in 'SQL Server 2005 Clustering' started by Foyura, Feb 3, 2008.

  1. Foyura New Member

    Hello.We have an Active/Passive cluster and the Active node failed. The failed node was removed from the cluster. It was re-built and added back to the cluster without SQL Server 2005 installed.The next step is to install SQL Server. Can't remember - but can I go into Add/Remove programs on the Active node and choose "change" and launch the SQL Server setup program and will the setup program detect the new node and install SQL Server on the new node?Or, do I do it on the new node from the install DVDs and will it detect the existing Virtual Server name?Thanks.
  2. satya Moderator

    BOL states:
    Start the SQL Server Setup program to begin your failover cluster installation. After you enter all necessary information, the Setup program installs a new instance of SQL Server binaries on the local disk of each computer in the failover cluster and installs the system databases on the specified cluster disk. The binaries are installed in exactly the same path on each cluster node, so you must ensure that each node has a local drive letter in common with all the other nodes in the cluster. A new SQL Server failover cluster instance with all failover cluster resources is created when SQL Server Setup completes the installation.

Share This Page