Solved

NLB for SQL Server 2005

Posted on 2010-09-02
4
603 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
  • 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

803 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