dbTalk Databases Forums  

Re: Active Active Clustering

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


Discuss Re: Active Active Clustering in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active Active Clustering - 05-24-2004 , 02:42 PM






You have a preferred owners list on the properties page of the resource
group. The host nodes are listed in preferred order. The actual ownership
can be changed by moving the group to a particular host. During setup, you
install SQL from the node that owns the disk resource where you intend to
put SQL. The dialog box you refer to selects the nodes that SQL is allowed
to run on. Once SQL is installed, the instance can be moved to any allowed
node.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"EY" <shafaqrahim (AT) hotmail (DOT) com> wrote

Quote:
I am planning to install Multiple Instance SQL Server 2000 cluster (two
instances) on Windows 2000 Advanced servers (two nodes). All the examples I
have seen deal with Single Instance SQL Servers. What I have read that in
case of a Multiple Instance installation you merely run the SQL Server setup
program another time after the installation of the first virtual server is
completed. I have also read that during the install you chose one of the
nodes (one of the two Windows boxes) as the owner of one virtual SQL Server
instance. Then when you run the SQL Server setup program a second time, you
specify the other node as the owner of the other SQL Server virtual
instance.
Quote:
My question is this: where do I specify a node as the owner of a
particular SQL Server instance? On the SQL Server 2000 Failover Clustering
white paper, Appendix B,
http://www.microsoft.com/technet/pro...on133121120120
step 10 shows a dialog box where you specify the configured nodes. Do I
specify only one node as the Configured Node? Is that how I identify the
node that owns the particular SQL Server instance? Or do I we identify it
some other way? Thanks.
Quote:




Reply With Quote
  #2  
Old   
Thanks
 
Posts: n/a

Default Re: Active Active Clustering - 05-24-2004 , 05:41 PM






Thanks Mr. Hitten for answering my question so promptly.

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.