Database Mirroring

  • Hi,

    Can anyone tell me how the Application users will recognize or connect to the Mirroring database once the failover had happened from primary server.

    Do we need to change the connection string manually on application servers once the fail-over is done, as the primary instance name and secondary instance name are different.? Or how will it recognize ?

    Many Thanks

  • bala2 (7/10/2014)


    Hi,

    Can anyone tell me how the Application users will recognize or connect to the Mirroring database once the failover had happened from primary server.

    Do we need to change the connection string manually on application servers once the fail-over is done, as the primary instance name and secondary instance name are different.? Or how will it recognize ?

    Many Thanks

    You do not need to change the connection string manually.

    All you need to do is just add keyword "Failover Partner=MirrorServerName" along with the other connection information in connection string.

    It should look something like this:

    "Server=PrimaryServerNameHere, Failover Partner=MirrorServerNameHere, Initital Catalog = DatabaseNameHere "


    Sujeet Singh

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply