Reinstall 2nd Node

Reinstall 2nd Node - SQLServer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shima - 25 Apr 2005 16:04 GMT

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 ?

Reply to this Message

Geoff N. Hiten - 25 Apr 2005 18:02 GMT

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

> 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 ?

Reply to this Message

Shima - 26 Apr 2005 14:35 GMT

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 ?

> Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
> step instructions on how to replace a failed cluster node.
[quoted text clipped - 7 lines]
> > reinstall
> > de second node and move the instance to it ?

Reply to this Message

Geoff N. Hiten - 26 Apr 2005 15:11 GMT

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

>I found on Technet a guideline about "Restoring a Node After a Catastrophic
> Failure"
[quoted text clipped - 16 lines]
>> > reinstall
>> > de second node and move the instance to it ?

Reply to this Message

Shima - 28 Apr 2005 18:20 GMT

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

> 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
[quoted text clipped - 24 lines]
> >> > reinstall
> >> > de second node and move the instance to it ?

Reply to this Message

Geoff N. Hiten - 28 Apr 2005 19:56 GMT

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

> Thanks for your informations.
> I tried to follow the instructions and the setup asked me to Uninstall the
[quoted text clipped - 40 lines]
>> >> > reinstall
>> >> > de second node and move the instance to it ?

Reply to this Message