Database Mirroring support in SQL Server 2017

Question

We currently have a SQL Server 2008 R2 Database configured with Mirroring between Production & DR.

We are upgrading to SQL Server 2017, our network infrastructure doesn't support clustering between Production & DR Regions, so we can't Always on Availability Group, we are left with Mirroring and Log Shipping.

With Log Shipping as there is a chance for Data Loss, we would like to continue using Mirroring.

We would like to know if we use mirroring in SQL Server 2017, will we get support from Microsoft, as its a feature that will be deprecated in future?

Answer 1

Hi,

I cannot tell you anything in the name of Microsoft but...

(1) deprecated does not mean obsolete. It means that it will be obsolete in the future (will be removed in a future), but it is still working feature and supported.

(2) I am not saying that you should do it but SQL Server 2017 doesn't strictly require Failover Clustered Instance (FCI) or WSFC for AlwaysOn AGs.

Check these posts:

https://sqlha.com/2017/02/22/alwayson-availability-groups-no-underlying-cluster-sql-server-v-next/
https://sqlmastersconsulting.com.au/SQL-Server-Blog/sql-server-2017-read-scale-out-availability-group/

Answer 2

As Ronen says, you can create clusterless Availability Groups in SQL 2017. Although some people claim that the right terminology is "read-scale groups".

Generally, clusterless AG are not HA solutions, since failover cannot be automatic. But they can certainly be DR solutions.

But if you already have mirroring running and are well acquainted with it, you may prefer to continue using it. There is little reason to change technology for the sake of it. (But would like to have a readable secondary, it would be a different matter.)

Answer 3

Hi LeelaPrasadKolipakula-7545,
Welcome to Microsoft Q&A.
In addition, the Database mirroring is still supported in SQL Server 2017.

Please refer to Editions and supported features of SQL Server 2017 which might help.
However, this feature will be removed in a future version of Microsoft SQL Server. It is recommended to avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.