Restoring an RDS database

Restoring an Amazon RDS database requires specifying multiple restore options. For more information about these options, see Backing Up and Restoring an Amazon RDS DB Instance in the Amazon RDS User Guide.

Use the AWS Backup console to restore Amazon RDS recovery points

1. Open the AWS Backup console at https://console.aws.amazon.com/backup.

2. In the navigation pane, choose Protected resources and the Amazon RDS resource ID you want to restore.

3. On the Resource details page, a list of recovery points for the selected resource ID is shown. To restore a resource, in the Backups pane, choose the radio button next to the recovery point ID of the resource. In the upper-right corner of the pane, choose Restore.

4. In the Instance specifications pane, accept the defaults or specify the options for the DB engine, License Model, DB instance class, Multi AZ, and Storage type settings. For example, if you want a standby database instance, specify Multi AZ.

5. In the Settings pane, specify a name that is unique for all DB instances and clusters owned by your AWS account in the current Region. The DB instance identifier is case insensitive, but it is stored as all lowercase, as in "mydbinstance". This is a required field.

6. In the Network & Security pane, accept the defaults or specify the options for the Virtual Private Cloud (VPN), Subnet group, Public Accessibility (usually Yes), and Availability zone settings.

7. In the Database options pane, accept the defaults or specify the options for Database port, DB parameter group, Option Group, Copy tags to snapshots, and IAM DB Authentication Enabled settings.

8. In the Encryption pane, accept the defaults or specify the options for the Encryption and KMS key settings.

9. In the Log exports pane, choose the log types to publish to Amazon CloudWatch Logs. The IAM role is already defined.

10. In the Maintenance pane, accept the default or specify the option for Auto minor version upgrade.

11. In the Restore role pane, choose the IAM role that AWS Backup will assume for this restore.

12. Once all settings have been specified, choose Restore backup.

    The Restore jobs pane appears. A message at the top of the page provides information about the restore job.

Use the AWS Backup API, CLI, or SDK to restore Amazon RDS recovery points

Use StartRestoreJob. You can specify the following metadata during Amazon RDS restores:

String dBInstanceIdentifier;
String engine;
String licenseModel;
String dBInstanceClass;
String availabilityZone;
Boolean multiAZ;
Boolean publiclyAccessible;
String storageType;
Integer port;
Integer iops;
Boolean autoMinorVersionUpgrade;
String dBParameterGroupName;
String optionGroupName;
List<String>  vpcSecurityGroupIds;
String dBSubnetGroupName;
Boolean enableIAMDatabaseAuthentication;
Boolean deletionProtection;
String dBName;
String tdeCredentialArn;
String domain;
String domainIAMRoleName;
Boolean copyTagsToSnapshot;
List<String> enableCloudwatchLogsExports;
List<ProcessorFeature> processorFeatures;

Example:

"restoreMetadata": "{\"LicenseModel\":\"postgresql-license\",\"StorageType\":\"gp2\",\"DBInstanceClass\":\"db.t2.small\",\"Port\":\"0\",\"AvailabilityZone\":\"us-east-1d\",\"OptionGroupName\":\"default:postgres-12\",\"ProcessorFeatures\":\"[]\",\"AutoMinorVersionUpgrade\":\"true\",\"DBSubnetGroupName\":\"default\",\"DeletionProtection\":\"false\",\"DBInstanceIdentifier\":\"cryo-instance-ec2-user-tlrq1\",\"DBParameterGroupName\":\"default.postgres12\",\"VpcSecurityGroupIds\":\"[\\\"sg-3ba6747b\\\"]\",\"EnableIAMDatabaseAuthentication\":\"false\",\"CopyTagsToSnapshot\":\"false\",\"PubliclyAccessible\":\"false\",\"MultiAZ\":\"false\",\"Engine\":\"postgres\",\"EnableCloudwatchLogsExports\":\"[]\"}"