Solved

NLB for SQL Server 2005

Posted on 2010-09-02
4
608 Views
Last Modified: 2012-05-10
Can we implement NLB for SQL Server 2005, i know that microsoft recommends active pasive cluser for sql db, but one of my client requries NLB for SQL 2005, any one share some links or documents about NLB for sql 2005 and the advntages,disadvantages of using NLB for SQL DB.
0
Comment
Question by:kumarnirmal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Assisted Solution

by:NormanMaina
NormanMaina earned 500 total points
ID: 33585458
0
 
LVL 7

Author Comment

by:kumarnirmal
ID: 33585563
How can i setup the NLB for 2 sql server nodes,
take the following senario i have the following servers

Node 1 - Read & Write Copy
Node 2 - Replica of Node 1(Read Only)
Node 3 - Replica of Node 1(Read Only)

I want to setup NLB between Node 2 & Node 3. How can i setup any step by step guides.


0
 
LVL 12

Accepted Solution

by:
NormanMaina earned 500 total points
ID: 33586070
This is similar to what you seek to do:

http://www.eukhost.com/load-balanced-servers.php
0
 
LVL 7

Author Closing Comment

by:kumarnirmal
ID: 33586630
thanks for your update.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question