question

jain.sachin.n avatar image
jain.sachin.n asked

Application should connect its own (without recycle application) in high safety mode database mirroring after failover

We have high safety mode (Automatic failover) database mirroring, and which is working good. But my question is regarding the application connections after failover and fails back, there should not be manual intervention in place to up the application after mirroring fails over. How can I do?
mirroring
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
You have to configure the application to be aware of the fail over. This is usually done via configuration files. Microsoft discusses it here: http://technet.microsoft.com/en-us/library/cc917713.aspx What I'm not sure of is if you fail back to the original mirror if that will pick up the correct server. Hope this helps!
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.