Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

active/passive and active/active

  
   Database Forums (Home) -> Clustering RSS
Next:  DECLARE CURSOR DATABASE option  
Author Message
Iter

External


Since: Mar 14, 2006
Posts: 55



(Msg. 1) Posted: Tue Jan 22, 2008 4:02 pm
Post subject: active/passive and active/active
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
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?

Thanks,

 >> Stay informed about: active/passive and active/active 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Tue Jan 22, 2008 8:56 pm
Post subject: Re: active/passive and active/active [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

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




"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?
>
> Thanks,
>
>

 >> Stay informed about: active/passive and active/active 
Back to top
Login to vote
Russ Kaufmann [MVP]

External


Since: Jul 12, 2006
Posts: 30



(Msg. 3) Posted: Wed Jan 23, 2008 8:47 am
Post subject: Re: active/passive and active/active [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"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 
Back to top
Login to vote
Iter

External


Since: Mar 14, 2006
Posts: 55



(Msg. 4) Posted: Wed Jan 23, 2008 9:28 am
Post subject: Re: active/passive and active/active [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(Msg. 5) Posted: Wed Jan 23, 2008 12:29 pm
Post subject: Re: active/passive and active/active [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]