Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Microsoft SQL Server Native Backup and Restore Support

Amazon RDS supports native backup and restore for Microsoft SQL Server databases using full backup files (.bak files). You can import and export SQL Server databases in a single, easily portable file. You can create a full backup of your on-premises database, store it on Amazon Simple Storage Service (Amazon S3), and then restore the backup file onto an existing Amazon RDS DB instance running SQL Server. You can back up an Amazon RDS SQL Server database, store it on Amazon S3, and then restore the backup file onto an on-premises server, or a different Amazon RDS DB instance running SQL Server. For more information, see Importing and Exporting SQL Server Databases.

Note

Native backup and restore for SQL Server is not supported on the db.t1.micro DB instance class. For more information about instance classes, see Specifications for All Available DB Instance Classes.

Native Backup and Restore Option Settings

Amazon RDS supports the following settings for the Native Backup and Restore option.

Option Setting Valid Values Description

IAM_ROLE_ARN

A valid Amazon Resource Name (ARN) in the format arn:aws:iam::account-id:role/role-name.

The ARN for an AWS Identity and Access Management (IAM) role to access the Amazon S3 bucket that contains your backup files. For more information, see AWS Identity and Access Management (IAM) .

Adding the Native Backup and Restore Option

The general process for adding the Native Backup and Restore option to a DB instance is the following:

  1. Create a new option group, or copy or modify an existing option group.

  2. Add the option to the option group.

  3. Associate the option group with the DB instance.

After you add the Native Backup and Restore option, you don't need to restart your DB instance. As soon as the option group is active, you can begin backing up and restoring immediately.

To add the Native Backup and Restore option

  1. Determine the option group you want to use. You can create a new option group or use an existing option group. If you want to use an existing option group, skip to the next step. Otherwise, create a custom DB option group. For more information, see Creating an Option Group.

  2. Add the SQLSERVER_BACKUP_RESTORE option to the option group, and configure the option settings. For more information about adding options, see Adding an Option to an Option Group.

    1. For IAM Role, select an existing IAM role. Alternatively, you can choose to have a new IAM role created for you by choosing Create a New Role.

    2. For Select S3 Bucket, select an existing bucket. Alternatively, you can choose to have a new Amazon S3 bucket created for you by choosing Create a New S3 Bucket.

    3. For Enable Encryption, choose Yes to encrypt the backup file. If you choose Yes, for Master Key you must also choose an encryption key. For more information about encryption keys, see Getting Started in the AWS Key Management Service (AWS KMS) documentation.

  3. Apply the option group to a new or existing DB instance.

Modifying Native Backup and Restore Option Settings

After you enable the Native Backup and Restore option, you can modify the settings for the option. For more information about how to modify option settings, see Modifying an Option Setting. For more information about each setting, see Native Backup and Restore Option Settings.

Removing the Native Backup and Restore Option

You can turn off the native backup and restore feature by removing the option from your DB instance. After you remove the Native Backup and Restore option, you don't need to restart your DB instance.

To remove the Native Backup and Restore option from a DB instance, do one of the following:

  • Remove the Native Backup and Restore option from the option group it belongs to. This change affects all DB instances that use the option group. For more information, see Removing an Option from an Option Group

  • Modify the DB instance and specify a different option group that doesn't include the Native Backup and Restore option. This change affects a single DB instance. You can specify the default (empty) option group, or a different custom option group. For more information, see Modifying a DB Instance Running the Microsoft SQL Server Database Engine.