Groups | Blog | Home
all groups > sql server clustering > april 2005 >

sql server clustering : Reinstall 2nd Node - SQLServer


Shima
4/25/2005 8:04:04 AM
Cluster active-active. The installation in one server was lost and the S.O.
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?
Geoff N. Hiten
4/25/2005 1:02:44 PM
Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
step instructions on how to replace a failed cluster node.

Geoff N. Hiten
Microsoft SQL Server MVP

[quoted text, click to view]

Shima
4/26/2005 6:35:02 AM
I found on Technet a guideline about "Restoring a Node After a Catastrophic
Failure"
In one of the steps is necessary Remove the node from a virtual server (SQL
Server). My doubt is if in this moment the instance will be unavailable.
The last step is install SQL Server. Is it possible rebuild node to the
virtual server before install SQL Server ?

[quoted text, click to view]
Geoff N. Hiten
4/26/2005 10:11:17 AM
Again, Books-On-line has specific step-by step instructions on how to
restore a node under these exact circumstances. If you do the installation
according to the instructions, the instance will not need to go offline. If
you do not follow the instructions, you may damage your installation.

Geoff N. Hiten
Microsoft SQL Server MVP


[quoted text, click to view]

Geoff N. Hiten
4/28/2005 12:00:00 AM
The SQL installer needs to modify the remaining bits on Node 1 to remove all
references to Node 2. In essence, it is erasing all traces of Node 2 from
the SQL instance. It will not completely remove your SQL instance. If this
is done correctly, the SQL instance currently running on Node 1 will not be
affected.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


[quoted text, click to view]

Shima
4/28/2005 10:20:04 AM
Thanks for your informations.
I tried to follow the instructions and the setup asked me to Uninstall the
Instance. What does it mean ? The instance will be removed physically ? My
doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
instances will keep available or not. I'm in production environment and the
instances can't be unavailable.
thanks,
Simone

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