Re: 2 node cluster - Witch Instance name ?

Tech-Archive recommends: Fix windows errors by optimizing your registry



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" <fhf@xxxxxx> wrote in message news:CF6AC4BB-E5AD-43DA-9FEB-58D1DEF6DD47@xxxxxxxxxxxxxxxx
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




.



Relevant Pages

  • Upgrading SQL 2000 Enterprise to SQL 2005 Enterprise
    ... We have a 2 node SQL 2000 cluster and are looking to upgrade to a 2 ... Enterprise and all the CAL's from scratch? ...
    (microsoft.public.sqlserver)
  • Adding Disks
    ... I would like to add another volume to my two node sql 2005 cluster. ... From what i have been reading i need to shut one of the cluster nodes, add the drive to the cluster then bring the backup node back on line. ... voice: 297-4451 ...
    (microsoft.public.sqlserver.clustering)
  • SUMMARY: changed WWID on cluster member boot disk
    ... disk and quorum disk of a single-member cluster, ... I could no longer boot from the cluster disks, ... the pre-cluster stand-alone system disk; ... the root1_domain on LUN containing the member boot disk was found ...
    (Tru64-UNIX-Managers)
  • Join an existing cluster
    ... I had a cluster setup with 2 computers running windows ... shared disk array. ... Creating a dummy Local Quorum resource. ... on the same storage bus as the boot disk... ...
    (microsoft.public.windows.server.clustering)
  • Re: Creating a wide area VMS Cluster
    ... > My goal is to provide a disaster tolerant cluster for both OS and data. ... disrupting the balance of the effect of votes between sites A and B. ... You have the option of a single shadowed system disk between the ...
    (comp.os.vms)