Skip to main content

Database Restore

When to Use​

  • Data corruption
  • Accidental deletion
  • Migration gone wrong

Steps​

  1. Create new instance from snapshot

    aws rds restore-db-instance-from-db-snapshot \
      --db-instance-identifier statux-prod-restored \
      --db-snapshot-identifier <snapshot-id>

  2. Wait for instance to be available (~10-15 minutes)

  3. Update Secrets Manager with new endpoint

  4. Restart applications to pick up new config

  5. Verify data and application functionality

  6. Delete old instance once confirmed