Tuesday, March 20, 2012

Reinstall 2nd Node - SQLServer

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 ?
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@.discussions.microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.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 ?
>
|||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@.discussions.microsoft.com> wrote in message
> news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...[vbcol=seagreen]
>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:
|||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@.discussions.microsoft.com> wrote in message
> news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:64C2F5EB-54A1-4233-87FA-122081210718@.microsoft.com...[vbcol=seagreen]
> 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:

No comments:

Post a Comment