If there is corruption in one database in an AWS sql server RDS instance, what is the best way to restore that one database? The backups are of the whole instance so you wouldn't want to restore from AWS backups and lose data on the other good databases.
Asked
Active
Viewed 9,343 times
2 Answers
19
When you restore from an RDS snapshot, you will create a new RDS instance. You do not restore "into" an existing RDS instance.
So you would restore the full RDS instance and use it to:
- replace the "old" instance (all databases), or
- pull the single database you want from the restored RDS instance and copy it's data to the original RDS instance.
If you are that concerned about individual databases, then you could keep the individual databases on their own RDS instances.
Matt Houser
- 33,983
- 6
- 70
- 88
-
1How to extract only a single database to a new instance ? – Nigel Fds Nov 29 '17 at 00:49
-
1You cannot. You can only restore all databases to a new RDS instance. – Matt Houser Nov 29 '17 at 00:53
-
Such an elegant explanation .. This will do ! – athulpraj Apr 02 '19 at 14:28
3
I believe it is now possible to restore an individual database to the same instance. The process is described here https://www.sqlshack.com/recover-data-in-aws-rds-sql-server/. Automated backups use storage volume snapshots, so I don't think it would work in that scenario.
FrugalShaun
- 166
- 7