Is database mirroring supported in SQL Server 2016?

Question

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. Use AlwaysOn Availability Groups instead.” 17 мар. 2016 г.

Is mirroring supported in SQL 2019?

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.

Is database mirroring deprecated in SQL Server 2019?

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.

Is SQL Server 2016 still supported?

July 14th, 2026 is the end of Extended Support for SQL Server 2016.

How do I check if SQL Server is mirroring enabled?

To view the status of a database mirroring session1After connecting to the principal server instance, in Object Explorer, click the server name to expand the server tree.2Expand Databases, and select the database to be mirrored.3Right-click the database, select Tasks, and then click Mirror.View the State of a Mirrored Database (SQL Server Management Studio)

Expert · Answer