dbTalk Databases Forums  

active/passive and active/active

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss active/passive and active/active in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Tom Moreau
 
Posts: n/a

Default Re: active/passive and active/active - 01-23-2008 , 11:29 AM






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" <Iter (AT) discussions (DOT) microsoft.com> wrote

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:

Quote:
"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote in message
news:42DB0B3E-C054-4AD6-8AD7-C7CBE0C28F8A (AT) microsoft (DOT) com...
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.