Forum Discussion

TWorku's avatar
TWorku
Frequent Visitor
10 months ago
Solved

Schema Mismatch on Mirror database from SQL Server

Hi everyone,   I’m having trouble with a mirrored database from SQL Server 2017. The initial synchronization works fine, but when the source data updates, I get a schema mismatch error.   After c...
data engineering
  • TWorku's avatar
    TWorku
    10 months ago

    The Alter command cannot be used on a mirrored database due to its read-only state.

    Thank you to lbendlin  and v-venuppu  for trying to help. The issue has been resolved by:

    1. Disabling and re-enabling CDC on the source database.

    2. Re-enabling CDC on all tables one by one.

    3. Creating a new connection with the latest gateway.

    4. Establishing a new database mirror.

    The solution has been stable and monitored successfully for the last four days

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
10 months ago

Hi TWorku ,

Great to hear that it's working from your end!I would suggest accepting your approach as the solution so that  It would be really helpful for others in the community who might be facing similar issues and can address them quickly. 

Thank you.