For a full list of available options, see Options for the Microsoft SQL Server database engine. In this post, we add an option for native backup and restore. Option groups in Amazon RDS provide flexibility to manage additional features. "Principal": Adding an option group for backup and restore Create a new role with this policy and add trust for Amazon RDS to assume this role. We have included a sample policy in this post for reference. When the files are available on Amazon S3, you create an AWS Identity and Access Management (IAM) role to provide Amazon RDS access to the S3 bucket with the backup files. To copy the files to Amazon S3, use the Amazon S3 console or the AWS Command Line Interface (AWS CLI). The backup files need to be in Amazon Simple Storage Service (Amazon S3) so they can be restored on Amazon RDS for SQL Server. Restoring a full backup to Amazon RDS for SQL Server We suggest creating a single Availability Zone RDS instance for migration purposes and modifying it to Multi-AZ at a later point. Restore subsequent transaction log backups to the latest point in time.Īs of this writing, differential and log restores are not supported on Multi-AZ instances.Because differential backups are cumulative, we restore the most recent differential backup since the last full backup. Restore a differential backup to Amazon RDS for SQL Server.Restore a full backup to Amazon RDS for SQL Server.The migration process can be described with the following high-level steps: The following diagram illustrates this architecture. On Amazon RDS for SQL Server, the native backup and restore functionality is supported with the help of stored procedures.įor this post, we use a self-managed SQL Server database that runs on the following backup schedule: With the help of differential and log backup, we significantly reduce application cutover time during the migration process. This involves performing a full backup followed by differential and log backups on the source instance and restoring the same backups to the target RDS for SQL Server instance.
In this post, we demonstrate how to use the SQL Server backup and restore features to migrate to Amazon RDS for SQL Server. Using SQL Server backup and restore features.
For more information, see migrate to Amazon RDS for SQL Server using transactional replication Using SQL Server transactional replication.For more information, see Migrating your SQL Server database to Amazon RDS for SQL Server using AWS DMS Using AWS Database Migration Service (AWS DMS).Amazon RDS also offers high availability using a Multi-AZ solution, replicating data synchronously across different Availability Zones.Ĭurrently, you can migrate self-managed SQL server to Amazon RDS for SQL Server using any of the following methods: Running Microsoft SQL Server on Amazon Relational Database Service (Amazon RDS) automates time-consuming administration tasks such as installation, disk provisioning and management, patching, minor and major version upgrades, and backup and recovery of your SQL Server databases.