All geek questions in one place

Configuring a backup database server in an ASP.NET web.config file

I currently have an asp.net site hosted on two web servers that are behind a Cisco load balancer. Two web servers link to the same MSSQL database server.

Since this database server is the only point of failure, I am adding an additional MSSQL server for backup. I would like to configure my web.config files to write everything to both MSSQL servers, but only read from the "primary" database server, if for some reason it is unavailable, and at that moment the backup MSSQL server will be used.

Is this possible with the web.config file parameter, or is it necessary to do this in code? Thanks in advance for any help.

New information: I just wanted to add additional information on this topic after studying it over the past few days - Microsoft TechNet has a good title for the article “Deploying an Application with Database Mirroring Failure” ( http://www.microsoft.com/technet/ prodtechnol / sql / bestpractice / implappfailover.mspx # EMD ).

This is especially true for the database mirroring feature in Microsoft SQL Server 2005 and the new Failover Partner connection string keyword, which allows you to specify two server / db instances on the same connection string.

The article is well worth reading if you are interested in implementing this type of function.

+3
source share
4 answers

, , "failover", , , . , . ..: SQL 2000, SQL 2005. , , . , () .

- , - . , , . Google, " " "".

+3

, . - ? ?

, , , , .

, ( ) , - SQL.

0

"", 2 . :

You may have your SQL Server 2 window waiting for a query, and it has a junior junior system with SQL Server 2005 Express as "health monitoring". To do this, you need $ 10K for a box and one SQL Server license. SQL Server Express (as in Free) can monitor health between two database servers without any problems.

This is my setup :)

0
source

Source: https://habr.com/ru/post/1698769/

More articles:


All Articles