Does SQL 2019 support database mirroring?

Question

SQL Server Database Mirroring is a technology used for disaster recovery scenarios and is used by many DBAs. Even though Microsoft states that it is a deprecated feature, it is still hanging around in SQL Server 2019. 17 янв. 2019 г.

Is database mirroring deprecated in SQL Server 2019?

Unfortunately, this feature has been deprecated, but still, some organizations use database mirroring as a high availability solution. Database mirroring can be configured in SQL Server Standard edition. It supports manual failover and automatic failover using the witness server (High Safety with automatic failover).

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.

Does SQL Server 2016 supports mirroring?

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 Server Standard support mirroring?

Database mirroring was first officially supported with SQL Server 2005 SP1. Database mirroring is available in Enterprise and Developer Editions and with some restrictions in Standard and Business Intelligence Editions.

Expert · Answer