Forum Discussion

wanwar's avatar
wanwar
Helper I
1 year ago
Solved

Mirroring on-prem SQL Server database

We started a new mirrored db in fabric pointing to an on-prem SQL Server database. CDC is enabled on the db and on couple of tables (for testing). Replication starts and shows 2 selected tables but no records imported. Suddenly both tables showing Failure with message "table does not exist" after I hit few refreshes it shows Running but no records imported and then suddenly fails again. Not sure what is the issue. 

data engineering
  • wanwar's avatar
    wanwar
    1 year ago

    Turned out cdc_capture and cleanup jobs were not created on the on-prem server for some reason, manually created those with cdc_enable_table SP, now Fabric mirroring is up and running

2 Replies

  • wanwar's avatar
    wanwar
    Helper I
    1 year ago

    Turned out cdc_capture and cleanup jobs were not created on the on-prem server for some reason, manually created those with cdc_enable_table SP, now Fabric mirroring is up and running

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Hi wanwar,

    Thank you for the update. We will now proceed to close this ticket. If you have any further queries or require assistance in the future, please feel free to raise a new ticket in the community forum.

    We appreciate your engagement and support.

     

     

    Thanks,

    Prashanth Are

    MS fabric community support