Is database mirroring deprecated?

Question

Database mirroring is a cost-effective and easy to configure high availability solution. Unfortunately, this feature has been deprecated, but still, some organizations use database mirroring as a high availability solution. 20 янв. 2020 г.

Is mirroring supported in SQL Server 2016?

As of February 2016, Microsoft states: “[Database Mirroring] will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Does SQL database support database mirroring?

Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.

What is deprecated in SQL 2019?

A deprecated feature is no longer under active development, and it may be removed from a future version. If we are building something new, we should avoid using that feature on the expectation that it will be gone in the future.

Does SQL Server 2017 support mirroring?

The principal and mirror server instances must be running on the same edition of SQL Server. For information about support for database mirroring in SQL Server, see Editions and Supported features of SQL Server 2017. The database must use the full recovery model.

Expert · Answer