0

I'm trying to Create a new AWS RDS SQL Server instance of only one database from a snapshot.

I've gone through the AWS documentation, but according to it when I restore from a snapshot it will create all the databases that were in it.

I wanted to just create a new instance with just one specific database from the snapshot.

I was hoping to achieve it using AWS SDK for .NET either using powershell or C#.

2 Answers 2

1

RDS Snapshots capture the entire server.

There isn't a way to restore only one database.

-1

Create a new RDS instance from the snapshot. Then extract the single database from it and populate your specific dB. Once done, remove the new instance you no longer need.

1
  • but then why would you even restore it?
    – Nigel Fds
    Commented Aug 12, 2021 at 0:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.