{"id":1231,"date":"2019-08-27T18:32:00","date_gmt":"2019-08-27T13:02:00","guid":{"rendered":"http:\/\/blogs.opstree.com\/?p=1231"},"modified":"2019-08-29T18:51:42","modified_gmt":"2019-08-29T13:21:42","slug":"aws-rds-cross-account-snapshot-restoration","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2019\/08\/27\/aws-rds-cross-account-snapshot-restoration\/","title":{"rendered":"AWS RDS cross account snapshot restoration"},"content":{"rendered":"\n
\"\"<\/a><\/figure>\n\n\n\n

Many a times you may have faced problem where your production infra is on different AWS account and non prod on different account and you are required to restore the RDS snapshot to non prod account for testing. <\/p>\n\n\n\n

Recently I got a task to restore my prod account RDS snapshot to a different account for testing purpose. It was a very interesting and new task for me. and I was in an awe, how AWS thinks about what all challenges we may face in real life and provides a solution to it.

For those who are not aware about RDS, I can brief RDS as a relational database service by Amazon Web Services (AWS), it is a managed service so we don\u2019t have to worry about the underlying Operating System and Database software installation, we just have to use it.

Amazon RDS creates a storage volume snapshot of your DB instance backing up the entire DB instance and not just individual database. As I told you, we have to copy and restore an RDS snapshot to a different aws account. There is a catch!, you can directly copy an aws snapshot to a different region in same aws account, but to copy to a different aws account you need to share the snapshot to aws account and then restore from there, so lets begin.

To share an automated DB snapshot, create a manual DB snapshot by copying the automated snapshot, and then share that copy.

Step 1:<\/strong> Find the snapshot that you want to copy, and select it by clicking the checkbox next to it\u2019s name. You can select a \u201cManual\u201d snapshot, or one of the \u201cAutomatic\u201d snapshots that are prefixed by \u201crds:\u201d.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Step 2:<\/strong> From the \u201cSnapshot Actions\u201d menu, select \u201cCopy Snapshot\u201d.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Step 3:<\/strong> On the page that appears: Select the target region. In this case, since we have to share this snapshot with another aws account we can select existing region.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n