On Database Mirroring

  • In Database Mirroring, when automatic failover happens through Witness Server, User connection would be automatically re-directed to Mirror Server (from Principal Server which is Live for applications).

    At Application level, does the connection changes automatically to Mirror Server or we need to change that at connection string?

  • ajay.g (6/30/2015)


    In Database Mirroring, when automatic failover happens through Witness Server, User connection would be automatically re-directed to Mirror Server (from Principal Server which is Live for applications).

    At Application level, does the connection changes automatically to Mirror Server or we need to change that at connection string?

    As with most things related to SQL server, it depends on how you have setup your connections to the mirrored instances:

    https://msdn.microsoft.com/en-us/library/ms366348(v=sql.100).aspx

    "For the initial connection to a mirrored database, a client must supply a connection string that minimally supplies the name of a server instance. This required server name should identify the current principal server instance and is known as the initial partner name.

    Optionally, the connection string can also supply the name of another server instance, which should identify the current mirror server instance, for use if the initial partner is unavailable during the first connection attempt. The second name is known as the failover partner name."

    MCITP SQL 2005, MCSA SQL 2012

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

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