configuring Active/Active...

My Current configuration is:
Windows 2003, cluster service, SQL 2000 sp3
I have 3 databases I want to run one in the cluster node1 and the other two
databases in the node2.
So, when node1 fail, node2 take the node1 DB and vice-versa.
Is possible? do you know some URL where I can find information about it?
Another question: In the Active/Active my applications always make a
connection to the Virtual Server or to each Instance?
Thanks
AA
Yes, this is possible. You will need separate physical disks for each
installation of SQL. Each instance corresponds to a virtual server so the
SQL connection is to the IP of the virtual server and the port of the
instance. Since each instance is on a separate IP address, you can have all
instances using the same port number. All that is required to create a
second installation is to run the SQL install agaon and create a new
clustered instance using new resources (disks, network name, IP address).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:e93uK5UdEHA.3732@.TK2MSFTNGP11.phx.gbl...
> My Current configuration is:
> Windows 2003, cluster service, SQL 2000 sp3
> I have 3 databases I want to run one in the cluster node1 and the other
two
> databases in the node2.
> So, when node1 fail, node2 take the node1 DB and vice-versa.
> Is possible? do you know some URL where I can find information about it?
>
> Another question: In the Active/Active my applications always make a
> connection to the Virtual Server or to each Instance?
>
> Thanks
> AA
>