Issue “msdb.dbo.rds_restore_database“. But, when database restore progress using “msdb.dbo.rds_task_status” received an error message.
Aborted the task because of a task failure or a concurrent RESTORE_DB request
Review SQL Instance and ensure that Option Group is pointing at the right S3 bucket.
Accessed “Option Groups“…
Selected Option by placing a check mark to the left of it, and clicking the Modify group
Options Group – …vs2017Express
- Installed Options :- SQLServer_Backup_Option
- S3 Bucket :- dba-bucket
Once our OptionGroup has been assigned SQLSERVER_BACKUP_RESTORE and it has been granted access to specific S3 bucket.