2 Replies Latest reply on Dec 4, 2017 11:59 AM by jamespr

    Other options beside SQL mirroring for AF High Availabilty Architecture

    jamespr

      Hello!

       

      The Life Library documentations indicates: "It is common practice to deploy AF servers so that each server uses a separate SQL Server, and mirroring is set up between the SQL Servers, as shown in the figure, below. The mirrored SQL Server is initially configured as read only. If the primary SQL Server fails, the "witness" server can automatically place the secondary SQL Server into write mode."

       

      Since that feature will be removed in future versions of Microsoft SQL Server, if there is other options like "Always On Failover Cluster Instances" and "Always On availability groups" that have been tested already for AF HA architectures?