load balancing

Hello,

How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application?

As long as both servers are ODBC-DB or OLE-DB compatible you can do this using Enterprise Manager or T-SQL code. It happens on server side.

Linked servers are listed under the security node under each server in EM. (Left hand pane) Right click node and select 'New Linked Server'

|||

Both servers are SQL Server 2000. What I am trying to achieve is to have a backup for our SQL Server so that if one of them is down, the other is still alive and serving the application. Is this possible? If I have linked server, does that provide me what I need?

|||No. You are looking for clustering.|||

Yes Motley is right.

Clustering will give the impression of two or more servers acting as one and thus provide high-availabiltiy.

A SQL Server cluster however do not balance the SQL load and will not provide scalability.