November 13, 2008 at 4:16 pm
Hi,
Is it possible to implememt automatic application failover in mirroring in 2005 without specifying Failover Partner='Partnername' in connection string?
TIA,
MJ
November 13, 2008 at 6:42 pm
I don't belive so, unless you use some sort of application trickery (some means outside of SQL server).
Is changing the connection string not an option?
Carlton..
November 13, 2008 at 8:49 pm
It's been a while since I tried this and my memory is hazy, but I believe that when the connection to the principal is made the mirror information is stored by the native client and hence will failover. If it's a new connection then it would need the failover partner information if the principal were to be unavailable.
November 14, 2008 at 3:52 am
Yes(ish) but you need to do the failover bit in your C# or VB code.
Try (connect to serverA, mydb)
Catch (connect to serverB, mydb)
That sort of thing. 😀
November 14, 2008 at 5:47 am
Thanks for your replies guys. As per Matt I think if sql native client is there then there is no need of specifying failover partner in connection string but if its not there then we do need to mention failover partner instance name so that application can connect to partner server is principal becomes unavailable.
Correct me if I got tht wrong.
Thanks again,
MJ
November 14, 2008 at 8:19 am
I think you should specify it .... if you start up the app and it attempts to connect to the principal, but failover has already occurred, then it won't know where to look for the failover otherwise. Is there some reason why you don't want to specify it?
November 14, 2008 at 12:29 pm
There is no such reason tht I don't want to specify but I just wanted to know when do we need to specify it and when its not required.
Basically I was clearing my doubt.
Thanks for replying,
MJ
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply