Database Restores

After backing up your databases, you can restore the databases by taking the following steps.

  1. In the Protection page, open the Databases tab.

  2. Select the database in the database list and click Restore to open the RDS instance restoration pane.

  3. In Step 1, see the summary section and ensure that you selected the database that you want to restore. Select one of the following restore types:

    Restore from point in time

    Specify the restore point by specifying the date range.

    Restore from available recovery points

    Select a restore point from a list of all valid restore points.

    After selecting a restore point, click Next to go to Step 2.

  4. In Step 2, enter the Job Name and the database identifier.

    Click Restore to create the restore job.

  5. (Optional) You can click Modify DB parameters and configure the following values:

    VPC security group ► Subnet group

    Specify the subnet group of your Amazon Virtual Private Cloud (VPC) account.

    VPC security group ► VPC security group

    Specify the security groups of your Amazon VPC account. You can select multiple items.

    See also

    For general information about Amazon VPC for Amazon RDS, see the following document:

    DB instance class

    Specify the DB instance class of Amazon RDS. First, select one of the following class groups:

    • Standard classes

    • Memory optimized classes

    • Burstable classes

    Then, select the database instance class from the drop-down list.

    See also

    For general information about the DB instance classes of Amazon RDS, see the following document:

    Include previous generation classes

    ***

    Click Next to go to Step 4, and configure the following values:

    Storage type ► Storage type

    Select the storage type from the following types:

    • Amazon EC2 General Purpose SSD (gp2)

    • Amazon EC2 Provisioned IOPS SSD (io2)

    • Previous generation volume types

    See also

    For general information about the DB instance classes of Amazon RDS, see the following document:

    Multi-AZ Deployment ► create a standby instance in another availability zone

    Enable this option to create a standby instance in a different Amazon RDS Availability Zone (AZ).

    See also

    For general information about Amazon RDS Multi-AZ deployments, see the following document:

    IAM Database Authentication ► authenticate database with IAM user

    Enable this option to authenticate database as the AWS Identity and Access Management (IAM) user.

    See also

    For general information about AWS IAM, see the following document:

    Database Parameter ► Database Parameter Group

    Specify the database (DB) parameter group of Amazon RDS.

    See also

    For general information about the DB parameter groups of Amazon RDS, see the following document:

    Database Parameter ► Database Option Group

    Specify the option group of Amazon RDS.

    See also

    For general information about the option groups of AWS RDS, see the following document:

    Click Restore to create the restore job.

  6. Go back to the Databases tab in the Protection page. In the main pane, open the Restores tab. In the list of restore jobs, you can run, edit, or remove the restore jobs you created. Find the restore job that you created and click Run now, and click Yes to proceed in the confirmation dialog.

  7. In the menu pane, open the Activity tab. In the activity list of database restore jobs, find the restore job that you ran in the previous step. If you see any status other than COMPLETED, click the activity item, and see the activity details to troubleshoot.