Restoring an Amazon DynamoDB Database
Start course
4h 25m

This section of the AWS Certified Solutions Architect - Professional learning path introduces you to the AWS database services relevant to the SAP-C02 exam. We then understand the service options available and learn how to select and apply AWS database services to meet specific design scenarios relevant to the AWS Certified Solutions Architect - Professional exam. 

Want more? Try a Lab Playground or do a Lab Challenge

Learning Objectives

  • Understand the various database services that can be used when building cloud solutions on AWS
  • Learn how to build databases using Amazon RDS, DynamoDB, Redshift, DocumentDB, Keyspaces, and QLDB
  • Learn how to create ElastiCache and Neptune clusters
  • Understand which AWS database service to choose based on your requirements
  • Discover how to use automation to deploy databases in AWS
  • Learn about data lakes and how to build a data lake in AWS

Hello, and welcome to this lecture looking at how to restore your Amazon DynamoDB tables from an existing backup, whether this is an automatic backup to be used as a future point-in-time recovery, or from a manual on-demand backup.

During a restore, you have the ability to change some configuration settings, such as restoring with or without secondary indexes, restoring to a different region, or encrypting your database using a KMS key. Let me now jump straight into a demonstration showing you some of these configurable options, both on how to restore using the point-in-time recovery function, in addition to a restore from an existing manual on-demand backup. Let's take a look.

As you can see, I'm in the DynamoDB dashboard of the AWS Management Console, and we're gonna be looking at how to restore from an existing backup, both the points-in-time recovery and also a manual backup. So if we take a look at our table again, and then if we go across to the Backup tab, we have our point-in-time recovery and also our manual backups as well.

So let's start with restoring from a manual backup. So this was the backup we took in the previous lecture. Now, to restore from this back up all we need to do is to select the backup and then click Restore backup. We can give this a new table name. So let's call this ManualRestore, and you can either restore the entire table data or restore it without the secondary indexes.

Now, you have the option to restore within the same region or to a different region. For this demonstration, I'm just going to leave it in the same region. And also you can change the encryption type as well, using KMS, either a custom-managed CMK or an AWS-managed CMK. I'm just gonna leave it as default, but you have the option to encrypt your restored database as well.

Now, once you've finished selecting those options simply click on Restore table. Now, as you can see here under our list of tables we have our new table being restored and we called it ManualRestore. So that'll take a few minutes to restore, so let me pause the video and we'll come back in just a moment.

Okay, our new table has now been created, and if we go to the items, then we can see the five products as well. So that's how you restore to a new table from an existing manual backup. So let's now restore from a point-in-time recovery. So let's say, for example, in the original table I accidentally deleted four of the items and I needed to get them back.

So what I can do, I can use a point-in-time recovery. So if I go across to Backups, here we can see both the earliest restore date and also the latest restore date. So I can restore to any point-in-time between those two dates and times. So let me now do that. So if I click on Restore to point-in-time, again, I can have a new table name. Let's call this point-in-time recovery restore. This is the latest restore date and time I can choose.

Let's go back six minutes. So this is the point in time that I want to restore to. And remember, this value here can be between the earliest restore date and the latest restore date. Now I want to restore the entire table data within the same region and using the same encryption type. So it's the same options as the restore from the manual backup. And then click on Restore table. So again, this is gonna take a little bit of time, so I'm just gonna pause the video here and then start it back up when it's complete.

Okay, the restore is now complete. Here is our new table. And if we go across to the items, then we can see that we have restored the table back with the four products that I accidentally deleted. So as you can see, it's very straightforward to restore from both a manual backup and also restoring using the point-in-time recovery feature.


Course Introduction - RDS Backup Capabilities - Restoring an RDS Database - Copying & Sharing RDS Snapshots - Amazon DynamoDB Backup Capabilities - Course Summary

About the Author
Learning Paths

Danny has over 20 years of IT experience as a software developer, cloud engineer, and technical trainer. After attending a conference on cloud computing in 2009, he knew he wanted to build his career around what was still a very new, emerging technology at the time — and share this transformational knowledge with others. He has spoken to IT professional audiences at local, regional, and national user groups and conferences. He has delivered in-person classroom and virtual training, interactive webinars, and authored video training courses covering many different technologies, including Amazon Web Services. He currently has six active AWS certifications, including certifications at the Professional and Specialty level.