By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Query Regarding AWS Backup and RDS Transfer

0

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.

Topics
Migration & ModernizationDatabase
Tags
AWS Database Migration ServiceAmazon RDS Proxy
Language
English
Paulo
asked a year ago278 views
1 Answer
0

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.

Awaneendra Tiwari
answered a year ago
profile picture
EXPERT
Giovanni Lauria
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content