Hi..We have a two node cluster. We have the SQL 2000 SP4 running andnow active only in one node as the passive node got something wrong andcorrupted. Restoring the backups also didnt work. So we have built upthat passive node from scratch. We have to again make this working as atwo node cluster. Is this possible to install the SQL in one nodemerging as a cluster pair while it is already running as a cluster inanother node after adding the node in the windows cluster ?
Yes, it is possible... Run the sql installation setup from the passive node and select the advance option for failover clustering... After SQL installation, make sure you apply the correct service pack and hot fixes as other node before you move sql server to new node. http://sql-server-performance.com/Community/forums/p/17515/17515.aspx http://technet.microsoft.com/en-us/library/cc917693.aspx