Restoring an Amazon RDS Instance to a Point in Time

You can restore an Amazon RDS instance to a point in time before the data becomes unusable.

Before You Begin

Ensure that you have enabled the point in time restore on the RDS (Snapshot) instance.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. On the Instances tab, in the Actions column for the instance, click the action button , and then click Restore.

   The Backup content page appears.

3. To restore the backed up data to a specific point in time, select Point in time restore.

4. Click the region, select the databases that you want to restore to a point in time, and then click RESTORE.

   The Restore options dialog box appears.

   You can only perform the point in time restores to the same cloud account.

5. In the Database identifier box, enter a name for the instance that will be created from the snapshot.

6. To make the instance accessible from the public internet, move the Public accessibility toggle key to the right.

7. To select a point to restore the data, do any of the following:

   • Latest restorable time: Select to restore to the latest restorable time.

   • Custom date and time: Select to restore to a custom date and time. Update the date and time you want to restore the data to, and then click SET.

8. To specify the availability zone (AZ) that you want to deploy the standby instance to, in the Advanced section, do one of the following:

   • To deploy to multiple availability zones, move the Multi-AZ deployment toggle key to the right.

   • To select the availability zone, from the Target availability zone list, select the availability zone that you want to create the instance in.

9. To change the compute and memory capacity of the instance, from the Instance class list, select the instance class.

10. To change the storage type, from the Storage type list, select the storage type.

11. To specify a database parameter group to associate with this database instance, in the Database parameter group box, type the database parameter group name.

12. To specify an option group to associate with the restored database instance, in the Option group box, type the option group name.

13. If the restored instance will have Microsoft SQL Server Integration Services (SSIS) enabled, type the domain in the Domain box.

14. To specify the instance profile associated with the underlying EC2 instance of an RDS Custom instance, in the Custom Iam Instance Profile box type the profile name.

15. To specify the elastic IP address to be associated with the underlying EC2 instance of an RDS Custom instance, in the Elastic IP box type the IP address.

16. If the restored instance will have SSIS enabled, type the domain IAM role in the Domain IAM role box.

17. In the Port box, enter the port number.

18. To enable automatic minor version engine upgrades, move the Auto minor version upgrade toggle to the right.

19. To define which subnets and IP ranges the cluster or instance can use in the Amazon virtual private cloud (VPC), in the VPC security group IDs box, enter the names of the security group IDs.

    You can add multiple security groups, separated by commas. For example, you can enter "sg-1122,sg-3344".

    For a cross-region replication and restore, if you don't want to use the default value, you must enter the security group ID.

20. Click SUBMIT.