SQL Server Performance

Mirroring Explicit Redirect

Discussion in 'SQL Server 2005 Database Mirroring' started by BikeBoy, Apr 6, 2007.

  1. BikeBoy New Member

    Hi all,

    From a developer's point of view, what would be a prefered method of connecting to a Failover Partner database:

    1. Include it in initial conn string as:
    "server=Partner_A; failover partner=Partner_B; database=AdventureWorks".

    OR

    2. Have a DNS alias on the DNS server, and the conn string will only connect to an alias?

    Thanks
  2. MohammedU New Member

    It is recommended to use first option without manual interference...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    IMHO & experience I would prefer manual intervention, as it gives more control to what you want to choose. Again the option of automatic and manual failover method depends upon your business logic, I have seen many shops out there don't want to choose automatic due to the dependancy of application on other components that are not aware of this auto-fail feature.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. MohammedU New Member

    Database failover manual should be fine but for application connection string when you have the option why don't we use it without changing the connection every time failover happens...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. satya Moderator

    Agreed, not contradicting on what you said I have seen many out there asking such reference. It is true that when you have option on appilication side you have an advantage. If the application is failover-aware then why not utilize to the extent.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. BikeBoy New Member

    THANKS GUYS!

Share This Page