How to set Change Data Capture (CDC) is available for 6 months?

• Qira

  SSCommitted

  Points: 1930

  More actions

  June 10, 2015 at 9:30 pm

  #304883

  Hello,

  The Change Data Capture (CDC) really cool. I've question

  1- How to set Change Data Capture (CDC) is available for 6 months?

  As a result, I can access the CDC within 6 months period.

  Please help

• Matan_Yungman

  SSC Eights!

  Points: 906

  More actions

  June 12, 2015 at 11:59 pm

  #1805292

  If you mean that you want the captured data to be retained for 6 months, you can use the sp_cdc_change_job procedure to configure it:

  https://msdn.microsoft.com/en-us/library/bb510748.aspx

  Keep in mind that it can get to a considerable size if it captures many changes from your tables.