Backup and Restore SQL Server to Amazon RDS Instance
If you are using Amazon RDS, you can't backup and restore in the normal way
with SQL Server Management Studio.
You have to upload your .BAK file to S3 and then run one of the special stored
procedures documented here:
Once you have uploaded your .BAK file to S3 just run the following to restore it
to your RDS instance (the stored proc is already included in RDS).
Backing up is just the reverse.
Below is a specific implementation of the instructions in the link above.
Upload your .BAK files to the
some-s3-bucket S3 bucket and all will be well.
sql-server-backup IAM policy allows you to backup and restore SQL Server
.BAK files from the S3 bucket
sql-server-backup IAM role with one policy,
RDS Option Group
Create an option group called
sqlserver-options. Make sure your RDS instance
uses this option group. You can specify this when you create the db or
sqlserver-options option group must have an option named
SQLSERVER_BACKUP_RESTORE that points to the
sql-server-backup IAM Role.
Thats all folks!