Load balanced and failsafe SQL Server setup

I need a failsafe configuration that will effectively route ODBC datasources between two SQL Server machines. Here is my configuration: 4 Web servers on the front. These are running Cold Fusion Server in conjunction with IIS4 and using ODBC to transact with two sql server machines. The 4 web servers are balanced using Cisco's Local Director machines. We would like to achieve the same balance with the backend. Along with the balance, we would like to make sure that if one machine goes down the other would get all of the hits. I am not sure if it matters, but we will just be running NETBEUI from the front machines to the back. Any software or hardware suggestions would be appreciated.

stevenvanooyenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zhanghlCommented:
I think you should run two SQL Server Enterpise Edition copies on two NT Server Enterprise Edition systems with a clustered architecture. The two SQL Servers can be load ballanced and the client programs would be failesafe to switch the physical data source, the logical data source specified by ODBC client will not be changed. SQL Server Ent Edition supports two instants on one server while the task handovered.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stevenvanooyenAuthor Commented:
Thanks for the answer.  I think that you have put me on the right track.  So, it will allow me to balance the work between the two SQL Servers and do the failover stuff I need?  Have you implemented this before?  Thanks for your help.
0
zhanghlCommented:
I have setup such a cluster NT system, but have not install SQL/ent yet.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

stevenvanooyenAuthor Commented:
Ok..  The one thing that I am looking for right now in the documentation is how the clustering handles the synchronization of the data from the db's on the two machines.  In other words, how will the cluster manage the two copies of the db that must exist on both systems to allow for both failover and load-balancing.  Do you know that?
0
zhanghlCommented:
Hi, how it goes? :-)
0
stevenvanooyenAuthor Commented:
We just now got the hardware from Compaq to setup the cluster.  I will try to remember to update this when we have it up.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.