change data capture

Question

we have some tables with change data capture enabled.

for some reason, we had to disable cdc on the database

now I have turned the cdc back on the tables,

will there the data be sunchronized or will there be any lag in the data capture to the target tables.

Answer 1

Hi @sqlniks-7244,

I think there may be any data lag after you enabling and disabling CDC.
If you only stopped the capture job, the change capturing process is not broken, as the changes will be processed once the job is started again. As the feature that can cause a delay in log truncating, the un-scanned transactions will not be overwritten, unless the feature is disabled on the database.
Please refer to About Change Data Capture and use SQL Server Change Data Capture which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.