Does SQL Server 2016 supports mirroring?

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. 17 мар. 2016 г.

How do I create a mirror in SQL Server 2016?

Expand SQL Server instance > Expand databases > Right-click on AdventureWorks2017 > Hover on Tasks > Select Mirror. The Configure Database Mirroring Security Wizard opens. On the first screen, you can view the details and the list of tasks performed by the wizard. Click Next.

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.

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 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