# Troubleshooting
<a name="SQLServer.Procedural.Importing.Native.Troubleshooting"></a>

The following are issues you might encounter when you use native backup and restore.


****  

| Issue | Troubleshooting suggestions | 
| --- | --- | 
| 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](Appendix.SQLServer.Options.BackupRestore.md#Appendix.SQLServer.Options.BackupRestore.Add). | 
| 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](Appendix.SQLServer.CommonDBATasks.ResetPassword.md).  | 
| 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](Appendix.SQLServer.CommonDBATasks.ResetPassword.md).  | 
| Access Denied | The backup or restore process can't access the backup file. This is usually caused by issues like the following:[See the AWS documentation website for more details](http://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Native.Troubleshooting.html) | 
| 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.<br />For more information, see [Compressing backup files](SQLServer.Procedural.Importing.Native.Compression.md).  | 
| 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.<br />For more information, see [Backing up a database](SQLServer.Procedural.Importing.Native.Using.md#SQLServer.Procedural.Importing.Native.Using.Backup).<br />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.<br />For more information, see [Restoring a database](SQLServer.Procedural.Importing.Native.Using.md#SQLServer.Procedural.Importing.Native.Using.Restore).<br />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.<br />For more information, see [Using native backup and restore](SQLServer.Procedural.Importing.Native.Using.md). | 
| 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.<br />For more information, see [Cross-Region replication](https://docs.amazonaws.cn/AmazonS3/latest/userguide/crr.html) 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. <br />For more information, see [Using native backup and restore](SQLServer.Procedural.Importing.Native.Using.md). | 
| 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. |