Re: Clustering Question

So let me see if I have this right. Here is what my situation is.

I will have two computer (nodes)
One computer will have Window Server Small Business Edition with Cable Internet
The Other computer will have Window Server Small Business Edition With DSL Internet And 1 Instance of SQL Server Edition deployed to both machines.

Is this correct?

Thanks,

Bryan


"Russ Kaufmann [MVP]" <russ@xxxxxxxxxxxxxxx> wrote in message news:363DBB7D-2DF9-4485-831E-3E53DB004A32@xxxxxxxxxxxxxxxx
"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message news:OSIqHu8FIHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for all the replies. But I am a little confused. If both machine don't have Sql installed and running how would they be redundant? Would you not need at least two machine running the same software?

When you install an instance on a cluster, you install the instance (the install of SQL) to all nodes if you want to allow it to run on all nodes. When you install a second instance (another installation of SQL in a different location), then you install it to all nodes if you want it to be able to run on all nodes.

Then, to make it active/active, you run one instance on one node and run the other instance on the other node.

Thus, instance1, if it fails on its active node, it will failover to the other node because all of the installation files are there for that instance. If instance2 fails on its active node, it will failover to the other node because all of the installation files are there for that instance, too.

Refer to the books online for more information about instances and how to install SQL on a cluster.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York

.

Relevant Pages

  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... Setup is supposed to install client tools on all nodes. ... Microsoft SQL Server MVP ... the first instance on the cluster. ...
    (microsoft.public.sqlserver.clustering)
Loading