Course contentsShow
← Cloud and Infrastructure
Lesson 2424 of 2,98952. Disaster Recovery and BackupFree lesson

Database Backup Approaches

Design backup strategies for managed databases including automated backups, point-in-time recovery, and export options.

Database Backup Approaches

What you'll learn: How to design robust backup strategies for managed databases using automated backups, point-in-time recovery, and export options.


Why Database Backups Are Different

Databases aren't just files—they're living systems with transactions constantly in flight. Unlike snapshotting a stopped VM, database backups must capture data in a consistent state while the engine keeps running. Think of it like photographing a busy highway: you need special techniques to get a clear picture.


Three Pillars of Database Backup Strategy

1. Automated Backups

Managed database services (RDS, Azure SQL, Cloud SQL) offer scheduled automated backups that run without manual intervention. These typically happen during maintenance windows with minimal performance impact. Automated backups capture the entire database state and are retained based on your backup retention policy (7 days, 30 days, etc.).

2. Point-in-Time Recovery (PITR)

Beyond full backups, PITR uses continuous transaction logs to let you restore to any second within your retention window. If a bad query corrupts data at 2:47 PM, you can roll back to 2:46 PM—not just the last nightly backup. This gives you granular RPO control, often measured in minutes or seconds.

3. Export Options

Logical exports (SQL dumps, CSV files) create portable copies independent of the cloud provider. These support migration, compliance archiving, and long-term cold storage. Exports complement automated backups—they're your 3-2-1 rule off-site copy.


Strategy Design Considerations

  • Application-consistent backups matter more for databases than crash-consistent snapshots
  • Balance RTO needs (restore speed) against RPO requirements (data loss tolerance)
  • Use incremental backups for large databases to reduce storage costs
  • Combine automated backups (fast recovery) with exports (portability and compliance)

Key Takeaway: Effective database backup strategies layer automated backups for quick recovery, point-in-time logs for precision RPO, and exports for portability—each serving distinct recovery scenarios within your RTO/RPO targets.