Tag Info

New answers tagged

0

The problem was that the retention period was set to the default of 3 days. I have extended it to one year using this script: EXECUTE sys.sp_cdc_change_job @job_type = N'cleanup', @retention = 525600; --set data retention for 1 year



Top 50 recent answers are included