Post reply

Database Mirroring -- do applications detect failover

  • March 29, 2011 at 10:08 am

    #247928

    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

    #1305003

    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


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • March 29, 2011 at 8:28 pm

    #1305233

    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

    #1305383

    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