On the Amazon RDS side panel, open the Option groups page and click the Create group button, configuring it as follows:
| Option | Value |
|---|---|
| Name | sqlserver-enable-restore |
| Description | Enables SQL Server backup restore |
| Engine | sqlserver-ex |
| Major Engine Version | 15.00 |
Click the Create button to finish creating the group. Open the newly created option group and in the Options section click the Add option button.
Configure the option to have the following values:
| Option | Value |
|---|---|
| Option name | SQLSERVER_BACKUP_RESTORE |
| IAM Role | Create a new role |
| IAM Role Name | rds-restore-backup-role |
| S3 bucket | Select a bucket where you will upload the backup file |
| Scheduling | Immediately |
Finish by using the Add option button to finish adding the option to the group.
You will see the following message:
