Re: Migrating stand-alone SQL server to cluster

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)