RDS restores
The Protection History calendar for a selected RDS resource displays the dates with available backups, where a dot represents an available backup. Refer to the legend below the calendar to see what type of backup is available. Click the date for which you want to restore your backup data.
The Record Retrievals card displays granular backup data that has been retrieved and is available for CSV download to your local machine. Hover over a record to see the query that was used to generate the output. Records will be available for 24 hours after record retrieval. Once a record has expired, you will no longer be able to download it. To download a record, click the Retrieve Record icon.
Recover an RDS resource from a SecureVault Standard backup
- Navigate to AWS > Protect > RDS Resources. The Available resources table displays with a list of RDS resources that have been inventoried into Clumio.
- Click the name of the RDS resource to restore. A detailed view of the resource displays. In the Protection History calendar, the colored dots displayed on each date in the calendar indicate the types of snapshots or backups taken on those dates that are available to be recovered or restored.
- Click a date with a dot corresponding to the SecureVault Standard backup on Clumio to recover, and then click Restore. The Restore dialog displays with the restore from SecureVault Standard backup option selected.
- Review the details and click Restore if the default selections satisfy your requirements. Otherwise click Switch to advanced mode.
- In the Restore To section, modify details per your requirements.
- Click Restore. Clumio starts a restore task. Once the task is complete, the backup is fully restored. Sign in to your AWS account through the AWS Management Console to see the restored database.
Retrieve RDS database content from a SecureVault Archive backup
- Navigate to AWS > Protect > RDS Resources. The Available resources table appears with a list of RDS resources that have been inventoried into Clumio.
- Click the name of the RDS resource you want to restore. A detailed view of the resource displays. The colored dots displayed on each date on the protection history calendar indicate the types of snapshots or backups taken on those dates that are available to be recovered or restored.
- Click a date with a dot corresponding to the SecureVault Archive backup you want to retrieve, and then click Prepare records for restore. SecureVault Archive backups require a thaw period before they can be restored. This can take up to 48 hours. An email will be sent to you on when the backup records are ready and you can perform an unlimited number of record restores for the next 7 days.
- When you access the backup, click Restore. A Record restore dialog displays.
- In the SQL Query text box, type the SELECT statement using the list of database tables and schemas as a reference to create the query. Optionally copy and paste the table and column names by clicking the copy symbol next to the name and pasting the text into the text box. Copying a table name copies its fully qualified name including the database name. Optionally, create joins between databases and tables within the RDS resource.
For example, select * from - Click Preview to see the first 10 records retrieved from the query. Each column of the preview pane is a fixed width, so some text may be cut off. Hover over the cell to display a pop-up with the full text.
- Click Initiate record restore. Clumio starts a record restore task to retrieve all records for the specified SQL query. When the task is complete, the results are ready to be downloaded. The Restored records tab on the asset details page for that RDS resource displays a list of all records that have been restored for each specified SQL query and their expiry dates. The record that you just restored appears at the top of the list, ready to be downloaded. Hover over a record to see the query that was used to generate the output. Records are available for 7 days. Once a record has expired, you can no longer download it.
- Click the Restore record icon to download the CSV file to your local machine before the expiry date.
Restore an AWS snapshot
Clumio inventories all your AWS snapshots when you connect your account. You can restore AWS snapshots that are managed by Clumio--if you selected the option in your RDS backup policy. If you also have AWS snapshots that are not managed by Clumio, you can view details about the snapshot and click View in AWS console to perform actions on that snapshot.
- Navigate to AWS > Accounts > Protect RDS Resources. The Available resources table appears with a list of RDS resources that have been discovered by Clumio.
- Click the name of the database name you want to restore. A detailed view of the resource displays. In the Protection History calendar, the colored dots displayed on each date on the calendar indicate the types of snapshots or backups taken on those dates that are available to be recovered or restored.
- Click a date with dot corresponding to the snapshot on AWS to recover, and click Restore. The Restore dialog displays with the Restore from AWS snapshots option selected.
- In the Pick a time drop-down list, specify to which point in time the snapshot is to be recovered. The snapshot is recovered up to the specified time.
- Review the details and click Restore if the default selections satisfy your requirements. Otherwise click Switch to advanced mode.
- In the Restore to section, modify any details per your requirements.
- Click Restore. Clumio starts a RDS AWS snapshot restore task. Once the task is complete, the backup is fully restored. Sign in to your AWS account through the AWS Management Console to see the restored database. If the original RDS Instance was on AWS Outpost, the snapshot is restored directly back to the Outpost.
Updated 12 months ago