What is deprecated in SQL 2019?

Question

Deprecation guidelines When a feature is marked deprecated, it means: The feature is in maintenance mode only. No new changes will be done, including those related to addressing inter-operability with new features. We strive not to remove a deprecated feature from future releases to make upgrades easier. 29 мар. 2022 г.

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.

Is SQL Server 2016 backward compatibility?

SQL Server 2016 is backwards compatible for the below SQL Server versions: SQL Server 2016 (130) SQL Server 2014 (120) SQL Server 2012 (110)

Is database mirroring deprecated 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.

Expert · Answer