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 2022-12-30 GMT+08:00
View PDF

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

Microsoft SQL Server as the Source in Synchronization

Table 1 Whether the CDC retention period in the source database is long enough

Check Item

Whether the CDC retention period in the source database is long enough

Description

Check whether the CDC retention period in the source database is long enough.

Failure Cause and Handling Suggestion

Failure cause: The retention period of CDC data in the source database is less than one day. As a result, incremental synchronization is 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