all groups > sql server replication > july 2007 >
You're in the

sql server replication

group:

Database Mirroring Question


Database Mirroring Question acmcdba68
7/31/2007 11:08:03 AM
sql server replication: I've read several instances that when implementing Database Mirroring, all
client connections are lost. A retry from client/s, applications, etc... will
reconnect to the Failover.

In order to compensate for the disconnect you should make use of TRY CATCH
logic within your code.

When going over that statement, TRY CATCH is not valid for disconnects so
how would you accomplish this feat?

What I mean is how could I allow my application to essentially reestablish
the coonection or look for the Failover from within my Connection String?

Many Thx,
--
RE: Database Mirroring Question DanMcClain
8/9/2007 9:48:01 AM
Need to utilize FAILOVER PARTNER=<Mirror SQL server> in your connection string.

[quoted text, click to view]
AddThis Social Bookmark Button