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
config is that you have to ensure that the virtual servers
are on its designated (preferred) server. You must also
remember to configure SQL Server memory manually to ensure
that each prosess has enough memory to start if they end
up on the same node. Normally 50/50.

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

HTH

Bjørn

The important thing to note is that each SQL Server instance needs a least
one physical shared drive dedicated to the SQL Server.

Rand
This posting is provided "as is" with no warranties and confers no rights.