active/passive and active/active

"Iter" wrote in message

> Hi,
> I am learning sql server failed over cluster and I got confused that what
> is
> difference between active/passive and active/active when you install sql
> server 2005 in cluster server. I read the installation of sql server 2005,
> I
> didn't find where do we need to indicate that. Could somebody give me tips
> how to do that?

Active/Passive is where one node hosts a virtual server (or more than one)
while the other node is just a hot standby waiting for failure of the first
node.

Active/Active is where both nodes are hosting virtual servers. For example,
Node1 will run one or more instances of SQL and Node2 will run one or more
instances of SQL.


--
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:
Mar 10- 13 in Denver
May 12-15 in New York
 >> Stay informed about: active/passive and active/active 

Thank you guys. I still have a a little bit question about installation.
1. If I install active/active, I need to install extra times for sql server
installation in order to install other instances, just like stand alone
server to install named instance, right?
2. I don't need to configue which one is primary server and which one is
failover server when configure active/active cluster, right?

thanks.



"Russ Kaufmann [MVP]" wrote:

> "Iter" wrote in message
>
> > Hi,
> > I am learning sql server failed over cluster and I got confused that what
> > is
> > difference between active/passive and active/active when you install sql
> > server 2005 in cluster server. I read the installation of sql server 2005,
> > I
> > didn't find where do we need to indicate that. Could somebody give me tips
> > how to do that?
>
> Active/Passive is where one node hosts a virtual server (or more than one)
> while the other node is just a hot standby waiting for failure of the first
> node.
>
> Active/Active is where both nodes are hosting virtual servers. For example,
> Node1 will run one or more instances of SQL and Node2 will run one or more
> instances of SQL.
>
>
> --
> 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:
> Mar 10- 13 in Denver
> May 12-15 in New York
>
 >> Stay informed about: active/passive and active/active 

Right on both counts.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Iter" wrote in message

Thank you guys. I still have a a little bit question about installation.
1. If I install active/active, I need to install extra times for sql server
installation in order to install other instances, just like stand alone
server to install named instance, right?
2. I don't need to configue which one is primary server and which one is
failover server when configure active/active cluster, right?

thanks.



"Russ Kaufmann [MVP]" wrote:

> "Iter" wrote in message
>
> > Hi,
> > I am learning sql server failed over cluster and I got confused that
what
> > is
> > difference between active/passive and active/active when you install sql
> > server 2005 in cluster server. I read the installation of sql server
2005,
> > I
> > didn't find where do we need to indicate that. Could somebody give me
tips
> > how to do that?
>
> Active/Passive is where one node hosts a virtual server (or more than one)
> while the other node is just a hot standby waiting for failure of the
first
> node.
>
> Active/Active is where both nodes are hosting virtual servers. For
example,
> Node1 will run one or more instances of SQL and Node2 will run one or more
> instances of SQL.
>
>
> --
> 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:
> Mar 10- 13 in Denver
> May 12-15 in New York
>
 >> Stay informed about: active/passive and active/active