can sql server 2000 database load balancing be achived by using sql clustering?
Say an active/active/passive type set up?
Thank you.

No, clustering is a hardware fail over solution only. There are no true
load balancing solutions for sql server at the moment. If you had strictly
read only data you could use NLB to point to multiple servers but falls
apart when you get into updates and such. You can use Distributed
Partitioned Views across servers but it has nothing to do with clustering
and is still not a true load balancing solution. SQL Server works best as a
scale up solution not a scale out.

--
Andrew J. Kelly SQL MVP


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

With SQL 2000 clustering each instance runs on a single machine, so the
Databases are not load balanced in any way.

You can A/A/P cluster, but each server would have its own instance or two.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

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