Can I have another Virtual SQL Server on the existing
Cluster (MS SQL 2000 Cluster)?.
Current configuration is SQL SERVER 2000 EE in an
Active/Passive two-node Cluster Configuration.
For example Cluster Name is CLUST1 and VIRTUAL SQL SERVER
is VS1.

My intention is to have one named instance of SQL Server
in another virtual SQL Server on both nodes. If this is
practicable what are the steps to achieve this and any
downside?.

Regards





Help appreciated.

Yes. Normal installation of a Virtual Server.

You need unique:

Network name
IP address
Data and log disks
Instance name

The problem with running an, so called, Active/Acvtive=20
config is that you have to ensure that the virtual servers=20
are on its designated (preferred) server. You must also=20
remember to configure SQL Server memory manually to ensure=20
that each prosess has enough memory to start if they end=20
up on the same node. Normally 50/50.

I don't like automatic failback. Use manual failback=20
instead. But I'm a control freak :-)

HTH

Bj=F8rn

[quoted text, click to view]