March 29, 2011 at 10:08 am
I never worked in a Database Mirroring environment. I only worked with Clustering.
I was wondering when a principal server fails over to a mirroring server, do you need to make any application changes?
I know fail over can happen automatically with a witness server. I'm just not sure how the application(s) will continue to work because I'm assuming the principal server and mirror server have different computer names.
Thanks!
March 29, 2011 at 10:14 am
Hi,
Check out this link. You can specify a failover partner in the db connection string of the application.
http://technet.microsoft.com/en-us/library/cc917713.aspx
Thanks,
Simon
March 29, 2011 at 8:28 pm
Test that you can failover and then take the principal server completely offline as well. I realise that this shouldn't make any difference but have seen a case where the application could only connect after a failover if the former principal was still online.
March 30, 2011 at 6:14 am
You will need to put the mirror server name in on the DB connection wizard (3rd screen, I think). Also, your application needs to have built in reconnect logic and support the concept of connecting to the mirror. Test your application in a failover scenario to see how it will behave. We have seen varying success with this based on the driver used and the ISV who wrote the application.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply