Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the CDC Retention Period in the Source Database Is Long Enough
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the CDC Retention Period in the Source Database Is Long Enough

Check whether the CDC retention period in the source Microsoft SQL Server database is long enough. If the CDC data is retained less than one day in the source database, incremental synchronization will be abnormal. Change the retention period to 1440 minutes (one day) or longer. The recommended value is 4320 minutes (three days).

Failure Cause

If the CDC data is retained less than one day in the source database, incremental synchronization will be abnormal.

Handling Suggestion

Change the CDC retention period to 1440 minutes (one day) or longer. The recommended value is 4320 minutes (three days).

For details, see the following statements:

EXECUTE sys.sp_cdc_change_job   
    @job_type = N'cleanup',  
    @retention = 4320;
Parent topic: Database Parameters