Loadbalancing and Failover for SQL Server and IIS!

[Jay Balapa]

Hello,

We have two Windows 2003 servers one running IIS and another for SQL Server.

We are at a stage where we need to load balance and provide a failover.

Can you show us a technical document which can help us do that?

Thanks.
-jay

 

[Juan T. Llibre]

You'll need to add more web servers to do that.
You don't need to balance load between the web server and the database server.

The "Planning Server Deployments" section of Technet has good info :

http://technet2.microsoft.com/Windo...18c7-4f1b-ac11-dd9f64fb8fa61033.mspx?mfr=true

Read everything there but, in particular, read :

Designing and Deploying Server Clusters
Designing Network Load Balancing
Deploying Network Load Balancing

Hello,

 

[Gaspar]

I would say:

- For IIS, use Network Load Balancing (*Load Balancing*)
- For SQL Server, use Database Mirroring (*Failover* - only available in
SQLServer 2005)

With this configuration in your current platform, you can simulate a
cluster, so if a server needs to be shutdown, the other can assume all
responsibility. Of course, both servers will need IIS and SQL Server
installed.

Then, if necessary, you can add more nodes to Network Load Balancing.
However, SQL Server 2005 Database mirroring is limited to only 2 servers.

There's a lot of information on Google about NLB and Database Mirroring.

Hope this helps.
Gaspar