Reinstall 2nd Node - SQLServer

#1

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 ?

#2

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 ?

#3

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 ?

"Geoff N. Hiten" wrote:

Quote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4 (AT) microsoft (DOT) com...
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 ?

#4

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 ?

"Geoff N. Hiten" wrote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4 (AT) microsoft (DOT) com...
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 ?

#5

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

"Geoff N. Hiten" wrote:

Quote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37 (AT) microsoft (DOT) com...
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 ?

"Geoff N. Hiten" wrote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4 (AT) microsoft (DOT) com...
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 ?

#6

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

"Geoff N. Hiten" wrote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37 (AT) microsoft (DOT) com...
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 ?

"Geoff N. Hiten" wrote:

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

"Shima" <Shima (AT) discussions (DOT) microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4 (AT) microsoft (DOT) com...
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 ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reinstall 2nd Node - SQLServer

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Reinstall 2nd Node - SQLServer - 04-25-2005 , 10:04 AM

Re: Reinstall 2nd Node - SQLServer - 04-25-2005 , 12:02 PM

Re: Reinstall 2nd Node - SQLServer - 04-26-2005 , 08:35 AM

Re: Reinstall 2nd Node - SQLServer - 04-26-2005 , 09:11 AM

Re: Reinstall 2nd Node - SQLServer - 04-28-2005 , 12:20 PM

Re: Reinstall 2nd Node - SQLServer - 04-28-2005 , 01:56 PM