How do I configure load balance cluster in SQL server

Question

1.00/5 (1 vote)

See more:

I want to configure load balance cluster in SQL server, how to manage that, please can any one help me.

What I have tried:

I didn't try yet, Cause this is first time for me, My company ask me to this senario

Posted 18-Mar-18 21:57pm

ABAKh

Updated 19-Mar-18 1:07am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2018-03-19T01:08:00

Solution 1

Start here: Load Balancing with SQL Server - Database Administrators Stack Exchange[^]
load balancing sql - MSDN[^]
If these aren't relevent then give us more information about your set up (SQL version, Database is Azure/not Azure)

Posted 19-Mar-18 1:08am

CHill60

Comments

ABAKh 20-Mar-18 11:36am

I appreciate your answer, as i knew that in SQL Server there is no load balance cluster, and instead of it there is fail over cluster, the question is, can i configure it while the database is working or before that, i mean on the installation of the database stage. Thank you a lot.

CHill60 20-Mar-18 12:16pm

You are not being at all clear with your question. Do you want to implement Load balancing or a failover cluster? I'm pretty sure neither can be done while the database "is working", you would have to stop the services and potentially reinstall or upgrade the SQL instance.
This sort of thing is somewhat off-topic for a "quick answers" programming forum - perhaps you should ask your company for some DBA training if they are going to ask you to do stuff like this