Forum Discussion
Issues Replicating Large CDC-Enabled Tables Using Microsoft Fabric SQL Server Database Mirroring
Hi spin1888 ,
I recommend raising a formal support ticket with Microsoft so the product team can review the issue in more detail. This will allow them to analyze backend logs related to your mirroring session, including the InputValidationError and timeout issues you mentioned.Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka Kota
Community Support Team
Hi spin1888 ,
Thanks for reaching out to the Microsoft fabric community forum.
Please go through the below documentation which may help you in resolving the issue:
Limitations in Mirrored Databases From Azure SQL Managed Instance (Preview) - Microsoft Fabric | Microsoft Learn
As this feature is still in preview, there are known scalability and performance limitations, especially for very large datasets. These limits are actively being worked on by the product team. I hope you understand well.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka Kota
Community Support Team
Thank you v-menakakota,
Unfortunately, I am not using the Mirrored Azure SQL Managed Instanced option. I am using the Mirrored SQL Server option (screenshot below) and meet all the conditions mentioned here:
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/sql-server-limitations
I couldn't find any documentation or notes indicating scalability and performance limitations with very large datasets. Hopefully the product team comes up with a resolution soon. That feature is a game changer for those interested in moving from on-prem to Fabric.
Hi spin1888 ,
I recommend raising a formal support ticket with Microsoft so the product team can review the issue in more detail. This will allow them to analyze backend logs related to your mirroring session, including the InputValidationError and timeout issues you mentioned.Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka Kota
Community Support Team