Amazon RDS for SQL Server supports integration of transaction log backup with DMS

Posted on: Aug 1, 2024

Amazon RDS for SQL Server now integrates transaction log backups with Database Migration Service (DMS). This integration provides greater reliability in data replication for customers using DMS to replicate data from an RDS for SQL Server source database. If database connection interruptions or sudden transaction volume spikes cause active transaction logs to be archived before DMS can finish processing, DMS can now access the RDS for SQL Server backup logs to recover and resume replication. This prevents replication failures that would previously require a full data reload.

The integration of transaction log backup with DMS is now generally available in all AWS regions where RDS for SQL Server is currently supported. To learn more about setting up ongoing DMS replication on a RDS for SQL Server DB instance, visit the documentation page.

Amazon RDS makes it simple to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for up-to-date pricing of instances, storage, data transfer and regional availability.