Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
user101010
Starting Member
1 Post |
 Posted - 2011-03-10 : 15:53:17
|
| Folks,I have two sql server databases lets say datbase1 and database2 participating in peer to peer replication (sql server 2008 R2) located on Server 1 and Server 2 respectively.My question is:what are different ways in which i can have my application failover the connection to database1 or database2I am looking for a solution whereby i don't have to manually failover from one node to other in case one server goes downIs there any best practice for achieving automatic failover from application if u r using replciation.I know i can achieve this by Clustering and Mirroring but how do i accomplish it if i am using Replication.I appreciate any help in advance.Thank you. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-10 : 19:21:38
|
| In your app, trap the error on connection to server1 and connect to server2 in the catch block. |
 |
|
|
|
|
|
Failover with SQL Server Replication