468,284 Members | 1,476 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

Loadbalancing and Failover for SQL Server and IIS!

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


Mar 26 '07 #1
2 2476
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/Window....mspx?mfr=true

Read everything there but, in particular, read :

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


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Jay Balapa" <jb*****@hotmail.comwrote in message news:uE**************@TK2MSFTNGP06.phx.gbl...
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

Mar 26 '07 #2
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

Jay Balapa wrote:
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

Mar 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by news.microsoft.com | last post: by
6 posts views Thread by kavallin | last post: by
1 post views Thread by theSpinel | last post: by
3 posts views Thread by afreema | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.