Re: Migrating stand-alone SQL server to cluster

Here's a TechNet link. This will reinstall SQL Server on the new cluster
node; however, to service pack that node is tricky: there is a registry hack
that you need in order to just update the binaries on the new node. You
need to contact Microsoft Product Support Services for the procedures as
they are not published.

Troubleshooting SQL Server 2000 Failover Clusters
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EGAA

Hope this helps.

Sincerely,


Anthony Thomas


--

"GaryC" <GaryC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:94AAEA9E-0691-453B-913F-4D25BE89A3B0@xxxxxxxxxxxxxxxx
When I select Option 2, the error comes up. "Cancel" exits the setup and
"OK" brings me back to the menu to choose options 1 or 2. Do I need to
re-run the setup on the new server where the SQL virtual cluster is
installed
and working?

Gary

"Geoff N. Hiten" wrote:

> Option 2) Advanced options. That is where SQL installer hides the virtual
> server/failover clustering options.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "GaryC" <GaryC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:CFB27364-C424-4179-81C0-9FCE66775759@xxxxxxxxxxxxxxxx
> >I was able to build the new server as a one-node cluster and installed
the
> > SQL virtual server successfully. The DBs re-attached fine and all the
> > data
> > looks good. I was also able to add the original server as a second node
> > to
> > the cluster, but I'm stuck at the point of re-installing SQL on the it.
> > When
> > I run the SQL setup on the original server (2nd node) I get to specify
the
> > virtual server, then it prompts me to with two options.
> > 1. Upgrade, remove, or add components to an existing instance of SQL
> > server.
> > 2. Advanced options.
> > If I choose 1. then my only path is to "Uninstall". If I choose 2. then
> > it
> > gives me an error saying "Changing installation options at this level is
> > not
> > allowed. If you do this, you will need to exit setup and restart."
> > What am I missing? Do I need to re-run SQL setup on the new server (1st
> > node)?
> >
> > Thanks.
> >
> >
> >
> > "Tony Sebion" wrote:
> >
> >> You should be able to install the clustering service with only one node
> >> and then install SQL Server on that one node. You can then transfer
the
> >> databases from the existing server to the new one-node cluster however
> >> you'd like to copy databases (copy and reattach mdb's, DTS, restore
> >> backups...). When the databases are moved and accessible on the
> >> cluster, add the 2nd node to the cluster service with Cluster
> >> Administrator, and re-run SQL Server setup to add the SQL Service to
the
> >> 2nd node.
> >>
> >> Good luck,
> >> Tony Sebion
> >>
> >>
> >> "GaryC" <GaryC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:B4CBAC01-F83B-413D-BDEE-F8600075BA4C@xxxxxxxxxxxxx:
> >>
> >> > I have a Windows 2003 Enterprise Ed. server running SQL 2000
Enterprise
> >> > Ed.
> >> > with SCSI attached storage. I have a new server (identical
hardware),
> >> > HP
> >> > fiber switches, etc to build a SAN config with the existing storage.
I
> >> > can
> >> > build the SAN portion fine, but I don't know how to transition the
live
> >> > SQL
> >> > server to a clustered config. Can I install the new server as a
stand
> >> > alone
> >> > cluster with SQL installed, then somehow tie the two together? I
don't
> >> > know
> >> > where to start. I've found a lot of info on building SQL clusters as
a
> >> > new
> >> > installation, but nothing that addresses this specific scenario. Any
> >> > ideas
> >> > or help would be appreciated.
> >>
> >>
>
>
>


.

Relevant Pages

  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... You can apply a service pack to a new node without taking the Virtual SQL ... server offline. ... When the install is asking for a virtual server name, ... one for the MSCS cluster or the one for the SQL cluster? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Exchange 2007 CCR on Windows 2008 x64 RTM
    ... install guide, but I always did it too quickly after the failure. ... I'm an MCITP on Server 2008 & Exchange ... I'm told that this is caused by the way the cluster service creates the ... respond to the start or control request in a timely fashion occured ...
    (microsoft.public.exchange.setup)
  • Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... SQL Server 2000 EE ... I had a three-node A/A/P cluster. ... Install SQL 2000 binaries on newly added node for Instance 1 ... "All cluster disks available to this virtual server are owned by other nodes." ...
    (microsoft.public.sqlserver.clustering)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
Loading