Tuesday, March 20, 2012

Cluster confusion, and instances?

Hey,
I am trying to setup a clustered SQL 2000 environement (active-active) with
3 instances UAT, DEV and PROD.
Should i be using 3 named instances ? Or do I install 3 virtual servers each
being a default instance? I know this is a newbie question but please some
help would be appreciated.
At the moment I would expect 3 virtual servers of SQL 2000 each with their
own IP and NETBIOS name? ie.
10.10.10.1
10.10.10.2
10.10.10.3
Or do i just create 3 named insstances?ie.
10.10.10.1\UAT
10.10.10.1\DEV
10.10.10.1\PROD
Any help is appreciated.
> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
Having PROD share a cluster with QA and DEV defeats the whole purpose of
having a cluster which is to provide high availability.

> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance?
You can use three named instances. You can't have three default instances in
the same cluster; you can have only one default instance in a cluster.
Linchi
"Daniel" wrote:

> Hey,
> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance? I know this is a newbie question but please some
> help would be appreciated.
> At the moment I would expect 3 virtual servers of SQL 2000 each with their
> own IP and NETBIOS name? ie.
> 10.10.10.1
> 10.10.10.2
> 10.10.10.3
> Or do i just create 3 named insstances?ie.
> 10.10.10.1\UAT
> 10.10.10.1\DEV
> 10.10.10.1\PROD
> Any help is appreciated.

No comments:

Post a Comment