Troubleshooting

Database backup/restore option is not enabled yet or is in the process of being enabled. Please try again later.

Make sure that you have added the SQLSERVER_BACKUP_RESTORE option to the DB option group associated with your DB instance. For more information, see Adding the native backup and restore option.

The EXECUTE permission was denied on the object 'rds_backup_database', database 'msdb', schema 'dbo'.

Make sure that you are using the master user when executing the stored procedure. If you encounter this error even after being logged in as the master user, it might be due to the admin user permissions being misaligned. To reset the master user, use the Amazon Web Services Management Console. See Resetting the db_owner role membership for master user for Amazon RDS for SQL Server.

The EXECUTE permission was denied on the object 'rds_restore_database', database 'msdb', schema 'dbo'.

Make sure that you are using the master user when executing the stored procedure. If you encounter this error even after being logged in as the master user, it might be due to the admin user permissions being misaligned. To reset the master user, use the Amazon Web Services Management Console. See Resetting the db_owner role membership for master user for Amazon RDS for SQL Server.

Access Denied

The backup or restore process can't access the backup file. This is usually caused by issues like the following:

BACKUP DATABASE WITH COMPRESSION isn't supported on <edition_name> Edition

Compressing your backup files is only supported for Microsoft SQL Server Enterprise Edition and Standard Edition.

For more information, see Compressing backup files.

Please reissue task with correct type and overwrite property

If you attempt to back up your database and provide the name of a file that already exists, but set the overwrite property to false, the save operation fails. To fix this error, either provide the name of a file that doesn't already exist, or set the overwrite property to true.

For more information, see Backing up a database.

It's also possible that you intended to restore your database, but called the rds_backup_database stored procedure accidentally. In that case, call the rds_restore_database stored procedure instead.

For more information, see Restoring a database.

If you intended to restore your database and called the rds_restore_database stored procedure, make sure that you provided the name of a valid backup file.

For more information, see Using native backup and restore.

Please specify a bucket that is in the same region as RDS instance

You can't back up to, or restore from, an Amazon S3 bucket in a different Amazon Region from your Amazon RDS DB instance. You can use Amazon S3 replication to copy the backup file to the correct Amazon Region.

For more information, see Cross-Region replication in the Amazon S3 documentation.

The specified bucket does not exist

Verify that you have provided the correct ARN for your bucket and file, in the correct format.

For more information, see Using native backup and restore.

The Restore task is unable to restore from more than 10 backup file(s). Please reduce the number of files matched and try again.

Reduce the number of files that you're trying to restore from. You can make each individual file larger if necessary.

Database 'database_name' already exists. Two databases that differ only by case or accent are not allowed. Choose a different database name.

You can't restore a database with the same name as an existing database. Database names are unique.