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

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

[quoted text, click to view]

Heelo AA,

Here are some links that you may find useful learning about SQL Server 20000 Failover Clustering

Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx

Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc051001/wcblurb051001.asp

Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc032602/wcblurb032602.asp

Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd061002/wcdblurb061002.asp

Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd101802/wcdblurb101802.asp

Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx