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.
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/pro.../failclus.mspx
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment