We are using SQL2000 and considering clustering the
solution. Could someone point us good documentation on
clustering. We are particularly interested in
Active/Active/Active/Passive

Thanks in advance
Amar

I assume you mean 4 nodes and 3 SQL instances? I haven't seen much
documentation on clusters with more than two nodes, but it is very much
possible. I have such a system running for about 8 months and it works very
well. Most of the standard clustering stuff applies, just with a few extra
twists. Here is a good overview on SQL failover clustering:

http://www.microsoft.com/technet/pro.../failclus.mspx


--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Amar" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Thanks a lot for your quick response.
One more question. Can we have
Active/Active/Active/Passive talking to single database?

Hi Thanks a lot for your quick response.
One more question. Can we have
Active/Active/Active/Passive talking to single database?

No. SQL clustering is a failover technology, not a scale-out technology.
Each instance has a unique set of databases and appears on the network as a
complete and unique virtual system. Read over the link I included to get a
better idea of what SQL clustering really does. It is critical to
understand the benefits and limitations of SQL clustering before you try and
build a highly available system around that technology.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Amar" <anonymous (AT) discussions (DOT) microsoft.com> wrote

No.

"Amar" <anonymous (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:2da4801c46a8d$88b60620$a401280a (AT) phx (DOT) gbl...