none
Mirror 2016 SQL DB

    Question

  • Hi Guys,

    Do you have a link to mirror SQL DB 2016 ?

    First machine is a VM and the backup server is a physical machine.

    Both Machine is running server 2016 standard.

    Thank you!

    Sid

    Monday, January 16, 2017 2:45 PM

Answers

  • >I am looking to continue operations if the primary server completely failed due to a fire. 

    If there is a fire, both machines will fail.

    >Is mirroring the best option ?

    For SQL 2016 Standard you should use AlwaysOn Basic Availability Groups instead.

    David


    Microsoft Technology Center - Dallas

    My Blog

    • Marked as answer by Sid_BK Monday, January 30, 2017 5:00 PM
    • Unmarked as answer by Sid_BK Tuesday, May 23, 2017 2:52 AM
    • Marked as answer by Sid_BK Tuesday, May 23, 2017 2:53 AM
    Wednesday, January 18, 2017 3:21 PM

All replies