
Amazon RDS for SQL Server now allows users to preserve Change Data Capture (CDC) configurations and metadata when restoring database backups using the KEEP_CDC option.


<div>
<p>
Amazon RDS for SQL Server has introduced a new feature that allows users to retain Change Data Capture (CDC) configurations when restoring database backups.
</p>
<ul>
<li>CDC tracks insert, update, and delete operations in database tables</li>
<li>Previously, restoring a backup would remove CDC configurations and data</li>
<li>New KEEP_CDC option preserves CDC metadata and captured change data</li>
<li>Users can maintain CDC settings when restoring to a new instance or database name</li>
<li>Feature is available in all AWS Regions supporting Amazon RDS for SQL Server</li>
</ul>
<p>
This enhancement helps customers maintain continuous data change tracking and reduces potential gaps in data capture during database restoration.
</p>
</div>


Related articles