what's difference between active/active and active/passive

And this one, too:

http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters...fault.a



--
Tom

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


"Uri Dimant" wrote in message

Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.com/searchSQLServer/downloads/SQL_Cl...er_Ezin -
---Steps Clustering
http://technet2.microsoft.com/windowsserver/en/library/32c40202-1043-4...-8dba-b
---All about CLustering







"Iter" wrote in message

>I have a question regarding configuration of active/active and
> active/passive, is there any difference between them when install sql
> server
> software in windows cluster. I look at doc and can not figure out what is
> difference between them. Can anybody give me some tips about it? Thanks.
>
 >> Stay informed about: what's difference between active/active and active/passive 

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.



"Uri Dimant" wrote:

> Iter
> Active/Active.....
> As Geoff pointed out in previous post those terminology is for SQL Server
> 7.0
>
> Shortly
>
> 1)Active-Active
>
> You have a cluster configuration with two nodes. On each node you have
> intalled SQL Server Instance.
> If one node failed over the second one becomes responsible for clinets. It
> is important to configure memory properly ( for example if you have 16GB on
> two nodes)
> assign 5-6GB for each one
>
> 2) Active Passive
>
> You have a cluster configuration with two nodes.But at this time you have
> intalled SQL Server Instance only on one node (Active)
> When it failed over the passive node (computer) becomes an active.
>
>
> Read these articles
>
> http://searchsqlserver.techtarget.com/searchSQLServer/downloads/SQL_Cl...er_Ezin -
> ---Steps Clustering
> http://technet2.microsoft.com/windowsserver/en/library/32c40202-1043-4...-8dba-b
> ---All about CLustering
>
>
>
>
>
>
>
> "Iter" wrote in message
>
> >I have a question regarding configuration of active/active and
> > active/passive, is there any difference between them when install sql
> > server
> > software in windows cluster. I look at doc and can not figure out what is
> > difference between them. Can anybody give me some tips about it? Thanks.
> >
>
>
>
 >> Stay informed about: what's difference between active/active and active/passive 

Yes. Each Instance requires a separate install.

Servers and Instances are independent in a cluster. You can arrange
Instances on whichever nodes suit you. Each instance has a preferred node
order to determine failover paths. It is a good idea to set these when you
have anything more complex than a single-instance cluster.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP



"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.
>
>
>
> "Uri Dimant" wrote:
>
>> Iter
>> Active/Active.....
>> As Geoff pointed out in previous post those terminology is for SQL Server
>> 7.0
>>
>> Shortly
>>
>> 1)Active-Active
>>
>> You have a cluster configuration with two nodes. On each node you have
>> intalled SQL Server Instance.
>> If one node failed over the second one becomes responsible for clinets.
>> It
>> is important to configure memory properly ( for example if you have 16GB
>> on
>> two nodes)
>> assign 5-6GB for each one
>>
>> 2) Active Passive
>>
>> You have a cluster configuration with two nodes.But at this time you have
>> intalled SQL Server Instance only on one node (Active)
>> When it failed over the passive node (computer) becomes an active.
>>
>>
>> Read these articles
>>
>> http://searchsqlserver.techtarget.com/searchSQLServer/downloads/SQL_Cl...er_Ezin -
>> ---Steps Clustering
>> http://technet2.microsoft.com/windowsserver/en/library/32c40202-1043-4...-8dba-b
>> ---All about CLustering
>>
>>
>>
>>
>>
>>
>>
>> "Iter" wrote in message
>>
>> >I have a question regarding configuration of active/active and
>> > active/passive, is there any difference between them when install sql
>> > server
>> > software in windows cluster. I look at doc and can not figure out what
>> > is
>> > difference between them. Can anybody give me some tips about it?
>> > Thanks.
>> >
>>
>>
>>
 >> Stay informed about: what's difference between active/active and active/passive