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

2 node cluster - Witch Instance name ?

 
   Database Forums (Home) -> Clustering RSS
Next:  large individual tables or not  
Author Message
CK

External


Since: Aug 13, 2007
Posts: 1



(Msg. 1) Posted: Tue Nov 20, 2007 4:57 pm
Post subject: 2 node cluster - Witch Instance name ?
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hello

I will setup a 2 node sql 2005 std. ed cluster with multi instance.

How maney instance can i run (16 total in standard ed.) ?, there is a small
base with low traffic inside each instance.

Witch instance name & virtual name shoud i use SQLINST01\SQLINST01 or can i
use the Cluster VIP name someshow.

If someone report a error on a instance is will be nice that we quick know
on with cluster it is.

If my cluster name is SQLCLU01 can i use that in the instance names:
SQLCLU01INST01\SQLCLU01INST01 or

Eksamble:

SQLCLU01\INST01
SQLCLU01\INST02
SQLCLU01\INST03

SQLCLU01INST01\SQLCLU01INST01
SQLCLU01INST02\SQLCLU01INST02
SQLCLU01INST03\SQLCLU01INST03

 >> Stay informed about: 2 node cluster - Witch Instance name ? 
Back to top
Login to vote
jason

External


Since: Nov 20, 2007
Posts: 18



(Msg. 2) Posted: Tue Nov 20, 2007 8:37 pm
Post subject: Re: 2 node cluster - Witch Instance name ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

They each need their own name, ip and disk although that is kind of
simplified. There is alot other factors to consider if you want to put that
many instances on two nodes.


--
Jason Massie
http://statisticsio.com



"CK" wrote in message

> Hello
>
> I will setup a 2 node sql 2005 std. ed cluster with multi instance.
>
> How maney instance can i run (16 total in standard ed.) ?, there is a
> small base with low traffic inside each instance.
>
> Witch instance name & virtual name shoud i use SQLINST01\SQLINST01 or can
> i use the Cluster VIP name someshow.
>
> If someone report a error on a instance is will be nice that we quick know
> on with cluster it is.
>
> If my cluster name is SQLCLU01 can i use that in the instance names:
> SQLCLU01INST01\SQLCLU01INST01 or
>
> Eksamble:
>
> SQLCLU01\INST01
> SQLCLU01\INST02
> SQLCLU01\INST03
>
> SQLCLU01INST01\SQLCLU01INST01
> SQLCLU01INST02\SQLCLU01INST02
> SQLCLU01INST03\SQLCLU01INST03
>
>
>

 >> Stay informed about: 2 node cluster - Witch Instance name ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Some help recovering a SQL 2005 two instance two node clus.. - Amazingly enough my client just lost the C: drive on both nodes (apparently they lost one drive a few days ago but nobody noticed until the other C: dirve was lost). Now they need to recover the cluster as soon as possible. Fortunately, they have ghos...

Installing a local instance of SQL on a Cluster Node - Hi I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server. I would like to install a local copy of SQL Server on the node that is currently passive - if I start the SQL install process, it does give me this option but I don't know what, if..

MSDTC issue on a two node/two instance SQL 2005 cluster - We have a two node cluster setup with SQL 2005 SP1 over Windows Server 2003 SP1 with two active instances. We also have a separate cluster group for MSDTC with its own ip address, network name and disk. We have already checked that network DTC is..

evicting a node from multi instance cluster - I have a three node cluster with three virtual sql server 2005 installed. Now I want to take one node out of cluster to make a two node cluster. According to the post of Daniel ("evicting a node") and other reading, we have to run the setup ...

4 node cluster - Has anyone set up a 4 node cluster i.e. 3 active and 1 passive ? I only want to consider this as it may reduce cost. We have a lot of servers and the least i want to do is have an active passive 2 node cluster for every server thus doubling the server...
   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 ]