Query Regarding AWS Backup and RDS Transfer

Question

Good afternoon, everyone!

I have a question about AWS.
I have the daily backups of an RDS stored in my AWS account, and I wanted to retrieve a backup from about 3 days ago and overwrite all the content of an RDS using it without needing to spin up a new instance to transfer the data. I just wanted to transfer the content of a backup or snapshot from one RDS to another existing RDS. Would that be possible?

I wouldn't like to use the DBMS because I don't want to copy directly from the instance in question, and I want the data from 3 days ago that is in one of the backups. However, I don't want to restore this backup to a new RDS but to one that I already have. Would that be possible?

Looking forward to your response.

Answer

Hi, AFAIK, Restoring a backup from Amazon RDS directly onto an existing RDS instance, effectively overwriting its data with the data from the backup, is not directly supported by AWS RDS. The standard process for restoring an RDS snapshot or backup involves creating a new database instance from the selected snapshot. If looking to revert an RDS instance to a previous state without creating a new instance, you could:

Backup the current state of the existing instance.
Restore the desired snapshot to a new instance.
Rename and replace the existing instance with the new one, adjusting any necessary configurations.

Hope this helps.

* Backup the current state of the existing instance.
* Restore the desired snapshot to a new instance.
* Rename and replace the existing instance with the new one, adjusting any necessary configurations.

Hope this helps.

Query Regarding AWS Backup and RDS Transfer

Relevant content