How to set Standby server
Posted
by
lasko
on Server Fault
See other posts from Server Fault
or by lasko
Published on 2010-12-23T23:20:30Z
Indexed on
2010/12/23
23:55 UTC
Read the original article
Hit count: 208
I have an application that connects to SQL Server 2008. What I want is to make a standby server (this standby server should be a mirror of the primary one). So that when the connection fails, the primary server should automatically switch to standby server without modifying my application. If there is way, please tell me in detail or even if there is third party product.
Note that I need to set the connection in my application to one server only.
© Server Fault or respective owner