Prerequisites for protecting Amazon RDS SQL Server database assets
You need to enable the native backup and restore options for the option group to protect RDS SQL assets.
This option group must be a part of the IAM role, which has an AWSBackupServiceRolePolicyForRestores/Backup policy attached to it.
To create an option group:
- On your AWS portal, go to IAM and create a new role.
- Attach the following permissions:
AWSBackupServiceRolePolicyForRestores
AWSBackupServiceRolePolicyForBackup
sqlNativeBackup
- Go to RDS > Option groups. Do the following:
Note:
Refer to the AWS documentation for the latest steps on adding the native backup and restore option to the option group for RDS SQL Server.
Create a group (Name: SqlServerBackupRestore, Description: xxx, Engine: Select your database engine, Major Engine Version: Select the version of your DB instance).
Click Create.
Click the created group to edit. Do the following:
Click Add option.
Select the option: SQLSERVER_BACKUP_RESTORE.
Select the IAM role you created in the previous steps.
Select Immediately, to schedule an instant change.
- Go to RDS > Databases and select your instance. Do the following:
Click Modify.
Select the option group you created in the previous step.
Click Next.
Select Apply immediately, to avoid service downtime.
Click Modify DB instance to apply the changes.
If you have a connection to database from the SQL Management Studio, close and connect again.
To use the bucket for protecting Amazon RDS SQL Server database assets:
For NetBackup versions before 10.2:
- Create the NetBackup AWS S3 bucket as:
netbackup-<AWS_ACCOUNT_IDENTIFIER> - If a bucket already exists with the same convention, NetBackup uses it.
For NetBackup versions 10.2 onwards:
- The bucket is automatically created, if it is not present, following the convention:
netbackup-<AWS_ACCOUNT_IDENTIFIER>-region