Re: Dear Ekrem Önsoy

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm not Ekrem, but...

We don't use the Active/Active and Active/Passive in the SQL Server world, because it is confusing and misleading. If you can explain what you mean by "Active/Active" then we can answer your question.

You can install several SQL Server instances in a cluster. Each instance is installed over a set of nodes (machines) in the cluster. A certain instance only executes on one node at a particular point in time, but can fail over to some other node. A particular node can at a certain point in time execute from zero to several instances.

So, we use the terms "number of nodes (machines)" and "number of SQL Server instances".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"SQLWay" <SQLWay@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FE5B303A-6E2D-498D-A747-AFDFA8888BF6@xxxxxxxxxxxxxxxx
again want to know about your expert opinion. Does Sql Server 2000 support
both modes of clustering i.e. Active/Active and Active/Passive ?

Regards
--
DBA

.

Relevant Pages

  • Re: Installing sp2 on active/passive cluster
    ... I want to install CU4 Build 3200, but I didn't see any instructions with it. ... I really have no cluster experience. ... Microsoft SQL Server MVP ... Do not end any running processes before you run the SP2 Setup program. ...
    (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: Upgrade from SQL 2000 to SQL 2005 Problem in Active/Active Cluster Environment
    ... IIS is required by some SQL Server ... To install all SQL Server features, ... NODE2 is not the node in the cluster that I'm logged into or the ... node the SQL instance I want to upgrade is on. ...
    (microsoft.public.sqlserver)
  • =?Utf-8?Q?Re:_Dear_Ekrem_=C3=96nsoy?=
    ... While to other people it can mean a load balancing cluster - a shared disk solution (which SQL Server doesn't support). ... You can install several SQL Server instances in a cluster. ... A particular node can at a certain point in time execute from zero to several instances. ...
    (microsoft.public.sqlserver.setup)
  • Re: Setup cluster SQL server in SAN due to task scheduler
    ... I rebooted both nodes of the cluster ... Microsoft SQL Server 2005 Setup ... Setup failed to start on the remote machine. ... To install all SQL Server features, install IIS from Add or Remove Programs ...
    (microsoft.public.sqlserver.clustering)