Amazon RDS for SQL Server now supports retaining CDC configurations when restoring database backups

Amazon RDS for SQL Server
Amazon RDS for SQL Server now allows maintaining Change Data Capture (CDC) settings and metadata when restoring native database backups. CDC is a Microsoft SQL Server feature that records insert, update, and delete operations in a database table, making these changes accessible to applications. Previously, CDC configurations and data were not preserved by default when restoring a database, leading to potential data gaps. With the new KEEP_CDC option, customers can ensure CDC metadata and captured change data are retained during a database restore.
What to do
- Use the KEEP_CDC option when restoring a database backup to preserve CDC settings.
- Refer to the Amazon RDS for SQL Server User Guide for more information.
Source: AWS release notes
If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.



