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

You would need to install multiple instances of SQL Server
to do what you want. So Ins1 would own DB1, and Ins2 DB2
and DB3. (Or Two instances ... whatever you want). The
way failover clustering works is that upon a failure, the
whole SQL instance will fail over to another node, so if
you had a failure on Ins1, it would go to Node 2 (or 3 or
whatever) automatically.

So I'm not sure what it is you're asking since you get
that functionality.

Your apps would connect to the SQL virutal server/instance
that has the DBs. On a cluster, a SQL virtual server is
an instance.

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 (AT) personal (DOT) net.py> wrote