Load balancing.

Hi!
I have two sql servers. One raid rack in the middle for them both.
I installe two cluster groups, with two sql installation.
Now I can put a db on one server and it can fail over to the other one and
the other way around. Fine.
But how can I set it up so the same db is located one both cluster groups
(on the raid and shared by both cluster groups) and use some kind of load
balacing system to harvest the power of both servers for one db.
The only ways I have found so far is DTC and replikation. DTC no slack in
time for having the db exactly the same on both servers, but needs knowledge
and rewrite of code to use DTC transactions. Replikation, slack in time in
update between the cluster groups.
Is there another way to do this? We want to use the power of both servers in
a normal situation, have the fail over if one goes down, only one copy of
the db. No slack in time between the both servers.
regards
cj
SQL 2000 Clustering is not capable of load balancing a database.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"Carl-Johan Wik" <cjwik@.hotmail.com> wrote in message
news:%23X%2334HRpFHA.708@.TK2MSFTNGP09.phx.gbl...
> Hi!
> I have two sql servers. One raid rack in the middle for them both.
> I installe two cluster groups, with two sql installation.
> Now I can put a db on one server and it can fail over to the other one and
> the other way around. Fine.
> But how can I set it up so the same db is located one both cluster groups
> (on the raid and shared by both cluster groups) and use some kind of load
> balacing system to harvest the power of both servers for one db.
> The only ways I have found so far is DTC and replikation. DTC no slack in
> time for having the db exactly the same on both servers, but needs
> knowledge and rewrite of code to use DTC transactions. Replikation, slack
> in time in update between the cluster groups.
> Is there another way to do this? We want to use the power of both servers
> in a normal situation, have the fail over if one goes down, only one copy
> of the db. No slack in time between the both servers.
> regards
> cj
>