• Database Mirroring is available on SQL 2005 SP1 onwards. It is built in to the RTM versions of all more recent versions of SQL Server.

    There will be fixes for data mirroring problems in all SPs of all versions, and in most CUs. It is best for a new build to be using the latest SP and CU.

    Although Data Mirroring is deprecated, it will still be available in SQL 2016. From SQL 2016 onwards there is a basic form of Availability Groups that will replace database mirroring in subsequent versions of SQL Server.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara