Veeam Cookbook
The Veeam Cookbook Series
A simple step by step no frills approach to achieving your goal
Recipe: Performing AWS RDS Database Restore
Expected deliverables:
An entire AWS RDS database recovered at the time of backup state.
Time to complete: 5 minutes
Ingredients:
- An AWS RDS Backup, either from, cloud-native snapshot, snapshot replicas, or image-level backup
- (For image-level backup) A Worker Configuration in the same region where the RDS Database will be restored. The worker must be deployed in the same AWS Account where the restored database resides.
- Veeam Backup for AWS does not support restoring RDS resources to the original location if deletion protection is enabled for the source resource.
- The target DB instance must be set to the same time zone as the source DB instance.
- The target DB instance must run the same or a later engine version as the source DB instance
Before you start: When restoring from image-level backup the database account that you specify for the restore operation will become the owner of all restored databases. Veeam Backup for AWS does not support restoring original database accounts.
Assumptions:
You have an existing Veeam Backup for AWS deployment, and backups of one or more AWS RDS Instances.
Method:
- Login the Veeam Backup for AWS web interface.
- Navigate to Protected Data > Databases > RDS. Select the RDS instance that you want to restore, and click Restore > Database Restore.
- At the Databases step, you can select the databases to be restored and select a restore point that will be used to perform to restore each database (by default the most recent restore point). Click Next.
- At the Account step, choose whether you want to use an IAM role of an AWS account or an AWS account of an AWS Organization with enough privileges to perform the restore operation.
- If restoring from image-level backup, then choose the IAM role that will be used by the worker, and it has enough privileges in the Production AWS Account.
- At the Instance step, specify the target AWS Region where a DB instance will host the restored databases, and choose the target DB instance. You must also specify credentials of a database account that Veeam will use to connect to the target DB instance (make sure tue DB account exists on the target DB instance)
- At the Reason step, specify a reason for restoring the RDS DB instance. Click Next.
- At the Summary step, review summary information and click Finish.
Links to Resources: