Re: Clustering Question...

Just to expand on what Rodney said, it is possible to create a cluster from existing equipment, but it is neither desirable nor supported. The potential disruption during the install and migration process will likely cause some unplanned downtime, which defeats the entire purpose of a cluster. It is best to start from a clean slate and migrate the data into the new system.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:ODTKVxJHHHA.4804@xxxxxxxxxxxxxxxxxxxxxxx
Clusters have built from the ground up. You can't make it a cluster after the install of SQL. Migrate to a new cluster, built from the ground up, that is the best option.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog

"Hassan" <Hassan@xxxxxxxxxxx> wrote in message news:%23PKJjfJHHHA.3872@xxxxxxxxxxxxxxxxxxxxxxx
Say I have a current standalone SQL 2005 node that is SAN attached.

How can I get it clustered by adding a passive secondary node to it ? Can I do so ? Or do I have to setup an entirely 2 new clustered set of servers and move the database from the standalone server to it ?

I am trying to avoid buying 2 new servers and move the database across but would like to just add another node to the existing standalone server and get it clustered. If this is possible, how can I do it ?






.

Relevant Pages

  • Re: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine ... member of the NLB cluster, setup NLB on it, plug the NICs ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Once again, ARP is an RFC standard, if you are having to make static entries in unicast mode, then your network device is not in compliance. ... Windows Server 2008 Readiness Team ... I was feeling nervous about our teaming-capable adapter as I read it might be sending out heartbeats, so I disabled it AND configured the cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine when no NLB is installed, but when it is, things start going screwy. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... One server with no cluster configured - all works ok. ... When static ARP mappings are added all works ok. ... I thought that the litmus test was that the router functions fine when ...
    (microsoft.public.windows.server.clustering)
  • Re: What is the best backup solution for failover cluster SQL Server
    ... Backing up your SQL database in a clustered environment is not different from a normal server. ... Create a cluster disk share so in the event of a fail over, all nodes will have access to the backup share. ...
    (microsoft.public.sqlserver.clustering)
Loading