question

LeelaPrasadKolipakula-7545 avatar image
0 Votes"
LeelaPrasadKolipakula-7545 asked AmeliaGu-msft commented

Database Mirroring support in SQL Server 2017

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?

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi LeelaPrasadKolipakula-7545,

Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
pituach avatar image
0 Votes"
pituach answered

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/



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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

120041-1.jpg


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.



1.jpg (48.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.