I once saw a presentation on different ways of load balancing web servers and SQL
servers to accomplish this. Im no expert but from what I remember the easiest way to
do this is to store the actual databases on a central machine and have the SQL Servers
feed from that central point. In terms
Yes this is possible , the swap over can happen at odbc level so it's
transparent to your apps / code. However this does require SQL server
Enterprise Edition running on NT enterprise Edition or the win2000 equiv.
Check out the lists @ http://www.swynk.com/
or look for a white paper on SQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul,
The overhead to check to see if a SQL server was up per query would
be enormous. Don't consider that option.
You're on the right track by setting up a second SQL server for
failover. If you want to have true failover, you'll need to purchase
Subject: RE: URGENT: Not OT: SQL Server Problems...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul,
The overhead to check to see if a SQL server was up per query would
be enormous. Don't consider that option.
You're on the right track by setting up a second SQL server for
failover. If you want
We have a SQL Server 7 implementation with three CF servers using it as a
database server.
The problem is that it's falling over regularly (and the technical guys
can't figure it out).
That's not the problem though. We are now setting up a second
SQL Server 7
for use as a failover. It
5 matches
Mail list logo