Is it required to enable FULL recovery mode of mssql database if CDC enable in the table level for AWS DMS on going repliation

Madura Pradeep 0
Viewed 16

AWS DMS recommends enabling FULL, Bulk logged recovery mode for ongoing replication tasks( prerequisites) But is it required if the table is CDC enabled?

The current recovery mode of my database is Simple and I can't change it for multiple reasons. So I am curious if CDC is enabled for the table, is it required to enable the Full recovery?

cdc aws-dms sql-server amazon-web-services
1 Answers

From the link:

During CDC, AWS DMS needs to look up SQL Server transaction log backups to read changes.

If they read changes from the log backups, then Simple recovery won't work as there are no log backups.

And I would be dubious about Bulk Logged actually working.

David Browne - Microsoft0
Related