Forum Discussion

spin1888's avatar
spin1888
Frequent Visitor
1 year ago
Solved

Issues Replicating Large CDC-Enabled Tables Using Microsoft Fabric SQL Server Database Mirroring

Hi everyone, We’re currently testing the Microsoft SQL Server (on-prem) Database Mirroring feature in Microsoft Fabric (Preview) and have encountered a critical blocker when attempting to mirror lar...
data warehouse
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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

ToddChitt's avatar
ToddChitt
Super User
7 months ago

v-menakakota 

I am trying to set up Mirrored On Prem SQL database to Fabric. I read this documentation from Microsoft Learn:

Limitations of Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn

 

It mentions that you cannot mirror a database in Version 2025 (17) if CDC is enabled. 

My server is version 16 (2022) and I am getting an error that says it cannot set up the mirror because there exists a user or schema in the database named "cdc". 

 

Is the documentation WRONG?