I'm using CDC feature to track changes that are being made, since the cleanup period is set to 3 days by default, I have to run jobs to archive this change data from the CDC system tables to my tables. However, there's a probability that CDC might delete a few change data records that I haven't been able to archive yet.

For instance, if i set the retention period to 10 minutes and run the cleanup job after 10 minutes, only the data that has been archived should be deleted, and the data that hasn't been archived should be left untouched. Is there a way around this predicament?

  • Can't you make sure that you always archive and empty well before (and I'm talking at least hours) the retention period expires? Commented Aug 26, 2015 at 10:12
  • Yea, that is one option, but if something goes wrong and you're unable to archive it, I want to be sure that I won't lose the unprocessed data Commented Aug 26, 2015 at 11:20
  • 1
    How long could something be wrong before you or clients would notice? Make the expiry time twice that. Commented Aug 26, 2015 at 12:44
  • Yes...you could disable the job and roll your own. But no, if you want to use what is created when you enable CDC. Commented Sep 2, 2015 at 19:18


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.