Forum Discussion
Fabric SQL Server Mirroring
- 6 months ago
Azure SQL Managed Instance is a PaaS service, hence this is not driven by the engine version per-se, but if you have either "Always up to date", SQL Server 2022 or 2025 update policy set up then it would fully support Mirroring.
details here:
Update Policy - Azure SQL Managed Instance | Microsoft Learn
Hello fabricpribeiro
Unfortunately neither of your on-premise SQL Server versions support mirroring. Microsoft Fabric SQL Server mirroring supports:
1) SQL Server 2016 - 2022
2) SQL Server 2025
Here's the Microsoft document reference
Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn
However, there is CDC support with both of your SQL Server versions. Please bear in mind only Fabric Data Factory Copy Job supports on-premise SQL Server as a CDC source.
Thank you very much, just one more question please. How about SQLServer Managed Instance? which versions support Fabric SQL MI mirroring?
- deborshi_nag6 months agoSuper User
Azure SQL Managed Instance is a PaaS service, hence this is not driven by the engine version per-se, but if you have either "Always up to date", SQL Server 2022 or 2025 update policy set up then it would fully support Mirroring.
details here:
Update Policy - Azure SQL Managed Instance | Microsoft Learn