Forum Discussion

goitom1630's avatar
goitom1630
Copper Contributor
Jan 05, 2024

SQL Mirroring vs Basic AG

I just started in this company, and they have database mirroring configured on their 2016 SQL Server Standard edition.    Will be better to setup basic Availability Group? is there benefit over mir...
Javier_Villegas's avatar
Javier_Villegas
MVP
Jan 07, 2024

Hi goitom1630 

 

You should consider that Database Mirroring will be removed in a future version of Microsoft SQL Server so for sure this will be a blocker if you attempt to upgrade.

 

I was a huge fun on Database Mirroring , it works very well but should consider moving out of discontinued features.

 

Also consider that there are no more fixes or improvements for it

 

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver16

 

Regards

Javier

goitom1630's avatar
goitom1630
Copper Contributor
Feb 11, 2024
Thank you for the help. I plan on doing that.

Resources