AnsweredAssumed Answered

Other options beside SQL mirroring for AF High Availabilty Architecture

Question asked by jamespr Champion on Dec 1, 2017
Latest reply on Dec 4, 2017 by jamespr



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?