Home Forums SQL Server 2014 Administration - SQL Server 2014 Having same server name for principal and mirror server, does it work? RE: Having same server name for principal and mirror server, does it work?

  • April 23, 2014 at 10:33 am

    #1708192

    Your developers should not use @@servername to check things. They should be working cross database only, with 3 part, not 4 part, names.

    I agree with Steve. I have a mirror that is setup with two different machines (each with a unique name, or course) and I have a DNS entire for a "virtual" server name that our application connections to. If we need to fail over we make a DNS change and they are now connected to the new principal. Why do your developers want to use 4-part naming?


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]