Post reply

Database Mirroring SQL Server 2014 Standard.

  • July 13, 2016 at 5:57 am

    #400399

    Hi ALL,

    I already setup a mirroring between two instances running on top of windows 2012 R2.

    It is setup in high safety with automatic failover.

    What i want is to know if i have an application that connects to the database and the principal goes down how the application will know where to connect. In linux i can assign in /etc/hosts one name like :

    # First Linux Box :

    192.200.30.1 myhostname

    # Second Linux Box

    192.200.30.5 myhostname

    i can have the same hostname defined in each box so the application will look for that hostname instead of the ip.

    How can i acomplished that with an application on windows to connect to SQL Server.

    Thanks for reviewing.

    Pvidal

    DBA.

  • July 13, 2016 at 6:02 am

    #1889821

    Perhaps this article gives you what you need to know?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 13, 2016 at 6:22 am

    #1889828

    Thanks for such quick response.

    That put me in the right direction.

    Paul Vidal

    DBA

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

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