Posted On: Sep 17, 2020

Amazon RDS for SQL Server now supports restoring SQL Server native backups onto DB instances that have read replicas configured. Previously, the read replica would need to be removed before restoring the native backup file onto your Amazon RDS for SQL Server DB instance. SQL Server backup files stored in your Amazon S3 bucket can now be restored directly on DB instances with read replicas.

To use SQL Server native backup/restore, you specify the S3 bucket that you want to use for storing the backup files. Grant RDS access to this bucket by creating an AWS IAM role, then associate the IAM role with your RDS DB instance.

To learn more about native backup/restore, see this blog post. To learn more about read replicas, see this blog post. Please visit the Amazon RDS for SQL Server User Guide to learn more.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.