Forum Discussion

XavierYan's avatar
XavierYan
New Member
1 year ago
Solved

Mirrored Sql Server Database Failed: Internal system error occurred.

When I try use the fabric mirroring to copy data from a on-premises sql server database, I followed the tutorial to create an on-premises data gateway and enable the cdc of database, and make sure th...
Mirrored Azure SQL Database
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Hello XavierYan 

     

    On-premises SQL Server is unsupported for direct Fabric mirroring

     

    The native feature only works with:
    • Azure SQL Database
    • Azure SQL Managed Instance


    Not sure which tutorial you are following 

     

    please accept the answer if this is helpful 

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi XavierYan  ,
    Thanks for reaching out to the Microsoft fabric community forum.
    As nilendraFabric mentioned on premises sql server is not supported yet and if you do want to ingest your data into Fabric, as a workaround you may use traditional methods of ingesting data into fabric Like Data pipelines. Create a data pipeline within Microsoft Fabric to extract data from your on-premises SQL Server. Use the copy activity to transfer data into Fabric, employing incremental load patterns as needed.

    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
    Thanks and Regards

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi XavierYan ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

  • lfparaujo's avatar
    lfparaujo
    Frequent Visitor
    1 year ago

    Hello team, now the Mirrored Sql is online on Fabric, but I'm having this same issue.