Active/Passive Multi-Intance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pankaj - 17 Feb 2005 23:39 GMT

Hi,

How many instances of SQL server I need to install in 2 - node server
cluster for Active/Active and for Active/Passive mode 'on each node' ?

Pankaj

Reply to this Message

Rodney R. Fournier [MVP] - 19 Feb 2005 20:39 GMT

SQL does not use the term Active or Passive. It's all about instances. With
Server 2003, you can run 16 instances within the cluster. Any node will be
albe to support as many as that node can hold :)

Cheers,

Rod

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

> Hi,
>
> How many instances of SQL server I need to install in 2 - node server
> cluster for Active/Active and for Active/Passive mode 'on each node' ?
>
> Pankaj

Reply to this Message

Donna Lambert [MS] - 24 Feb 2005 21:36 GMT

Pankaj,
Rod is correct.
I think you might want to review the following whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

and the following topics in BOL;

SQL Server 2000 Failover Clusters
Failover Clustering FAQ
Failover Clustering

Hope that helps!
Thanks
Donna Lambert
Microsoft SQL Server Product Support

Reply to this Message