no you can't have more than two hosts in a MSCS cluster.
If you have excess hardware capacity, and don't expect
activity to change much in the next year, you can set up
both SQL 2K instances on a single cluster. But that will
require lots of resources.
I have done this with some Profusion based hosts (8 xeon
cpus per host). The SQL data is located on an HP EVA 5000,
so there is tons of capacity for growth. Mind you, I
inherited these hosts from a guy who bought way to much
hardware than he needed. Not to mention $300,000 in SQL
CPU licenses.
My practice is to build each cluster to support a specific
line of business application. Don't put all of you eggs in
one basket. MSCS is good, but it isn't highly available or
fault tolerant if you aren't very picky with hardware
interoperability, not to mention OS and applications.
chr$
-----Original Message-----
I am looking to build two separate clusters running SQL
2000. They will each be active/passive. Can I leverage
the passive server for the first cluster to be the passive
server for the second cluster. Does the quorum or
registry prevent me from having a server be part of 2
different cluster configurations?
