AWS Certified CloudOps Engineer - Associate

Database Restore Strategies

RDS automated backups and point-in-time recovery, manual snapshots and cross-Region copies, Aurora continuous backups, cloning and Backtrack, and DynamoDB PITR, including the settings every restore silently leaves behind.

Intermediate 28 minutes 6 Learning Objectives
  1. Explain how RDS combines daily snapshots with 5-minute transaction log uploads to make point-in-time recovery possible
  2. Predict the latest restorable time for a DB instance and the data loss a restore to that point implies
  3. Distinguish automated backups from manual snapshots by retention, deletion behavior, and quota
  4. Choose between point-in-time recovery, snapshot restore, Aurora cloning, and Aurora Backtrack for a given recovery scenario
  5. List what a DynamoDB restore does not carry over and why that matters to your RTO
  6. Plan the endpoint cutover that every RDS restore requires, because a restore never replaces the source