# Restoring an Amazon RDS Instance to Same Region in the Same AWS Cloud Account

You can restore an Amazon RDS instance to the same AWS cloud account within the same region using either a primary snapshot copy or a secondary (auxiliary) snapshot copy.

Option | When to use
--- | ---
Primary snapshot copy | Use when the snapshot is available in the primary copy.
Secondary snapshot copy | Use when the snapshot is stored in a secondary copy, such as a replicated or long-term retention copy, typically for disaster recovery scenarios.

## Restore using a primary snapshot copy

1. From the Command Center 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 a snapshot, click the region, and then select the snapshot that you want to restore.

4. Click Restore.

   The Restore options dialog box appears.

5. By default, same cloud account (source account) will be selected from the Cloud account list.

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

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

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 define the subnet group, in the Subnet group box, type the subnet group. Specifying a subnet group may limit the choice of availability zones.

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

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

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

15. 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.

16. 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.

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

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

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

20. 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".

21. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       - Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

22. Click Submit.

## Restore using a secondary snapshot copy

Use this option when the snapshot is available in an auxiliary copy but you want to restore the instance to the same region in the same account.

### Why use a secondary (auxiliary) snapshot copy

A secondary snapshot copy is a replicated or additional copy of your data that is stored separately from the primary copy. You might use a secondary copy in the following situations:

- The primary copy is unavailable, deleted, or expired

- You are performing a disaster recovery operation using a replicated copy

- The required snapshot is retained only in long-term or archival storage

- You want to validate recovery from a secondary storage location

### Prerequisites

- Create a secondary snapshot copy on the associated backup plan and enable replication on the instance. For more information, see configuring cross-region restores.

- If the AWS RDS Database is KMS encrypted, ensure that it meets the KMS Key Permission Requirements for Amazon RDS Using Snapshot.

### Procedure

1. From the Command Center 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. On the top-right of the page, click Change source.

   The Change source dialog box appears.

4. From the restore from copy list, select the secondary snapshot copy, and then click Ok. Based on the Mapping provided in the secondary snapshot copy, the region on the backup content page gets updated.

5. To restore a snapshot, click the region, and then select the snapshot that you want to restore.

6. Click Restore.

   The Restore options dialog box appears.

7. By default, same cloud account (source account) will be selected from the Cloud account list.

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

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

10. To deploy the instance to the source region, from the Target availability zone list, select the source region availability zone.

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

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

13. To define the subnet group, in the Subnet group box, type the subnet group. Specifying a subnet group may limit the choice of availability zones.

14. In the KMS Key ARN box, enter the KMS encryption key of the corresponding source region availability zone selected above.

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

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

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

18. 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.

19. 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.

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

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

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

23. 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".

24. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       - Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

25. Click Submit.

×

Loading...