Re: cluster with 1 server ok and second not,...

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Shane Flagstad [MSFT] (shanefl_at_online.microsoft.com)
Date: 04/22/04


Date: Thu, 22 Apr 2004 11:20:10 -0700

The DB will stay on online on the primary node Y while you install X.

Follow these steps:

     1.) Uninstall SQL from node X

Run SQL setup on node Y

Enter the DB name for Virtual Server

            Select "Advanced Options"

            Select "Maintain a Virtual Server for Failover Clustering"

            Enter the Virtual IP

            Select node X and click "Remove" then next

2.) Evict Node X from the cluster

3.) Disjoin Node X from the Domain

4.) Install Node X

Make sure the system drive is same as before, if C: needs to be C: again

5.) Join to Domain

6.) Add Node X to cluster

7.) Install SQL on node X

Run SQL setup from Node Y

Enter the DB name for Virtual Server

            Select "Advanced Options"

            Select "Maintain a Virtual Server for Failover Clustering"

            Enter the Virtual IP

            Select node X and click "ADD" then next

-- 
Shane Flagstad
Windows Server Group, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.
"Please do not send e-mail directly to this alias. This alias is for 
newsgroup purposes only."
"Colemont Bert" <colemont.bert@pi.be> wrote in message 
news:eYUR0wEKEHA.556@tk2msftngp13.phx.gbl...
> Hi all,
>
> The problem that we have:
>
> We have a SQL cluster which contains 2 windows Adv servers, server X and Y
> Y is the primary node, and on that node is a virtual SQL installed, X is 
> the
> secondary node, but it needs to be reïnstalled,
> as there is a db running on the cluster, I wonder if it would have impact 
> as
> our db needs to stay online and how I need to do that?
>
> Do I need to evict the second node and then reïnstall it, or just 
> reïnstall
> it?
> Do I need to install the virtual SQL also on the second node or not?
>
> 


Relevant Pages

  • Re: about another instance of virtual server on sql2000 cluster
    ... Multiple instances on a cluster look and act just like multiple ... Microsoft SQL Server MVP ... > the new instance of sql virtual server is myclustersql02\myclustersql02 ... You can specify the same path, and the install will create a ...
    (microsoft.public.sqlserver.clustering)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to install service pack 3a on a failover cluster
    ... have said that the unpacking of the install files went well:) I know, ... supply the name of the virtual server but it would not take the name. ... We have two instances of sql running so I ... the second node and rebooted the first node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)