We have 2 SQL 2012 SP2 Enterprise servers that have some mirrored databases. One of these databases also has CDC enabled on a number of tables so that we can run some business logic when there are changes to the table.
Yesterday we did some maintenance on the mirror server (the primary was running exposed). A few hours later we re-enabled the mirror and it synchronised as expected.
What we found out was that the CDC data that we normally process close to real time didn't get collected until after the mirror was resumed.
2 questions out of this:
- When you have a mirror configured, is CDC data only collected when the mirror is synchronized?
- Is there anyway to make CDC capture run when a mirror is paused?