Backups and Restore

Backup Coverage

  • Database dumps (MySQL, Postgres, and service-specific DBs)
  • Service files and storage snapshots
  • Secret/config backups where required

Primary Scripts

  • Dreambau-Database/backups/automated-backup.sh
  • Dreambau-Database/backups/restore-backup.sh

Backup Policy

  • Daily or weekly scheduled jobs
  • Verify backup file integrity
  • Keep retention policy documented
  • Test restore regularly

Backup SLO Targets

  • Backup success rate >= 99%
  • Recovery point objective (RPO) defined per service
  • Recovery time objective (RTO) tested quarterly

Restore Checklist

  1. Restore into staging first
  2. Validate app integrity and login flow
  3. Validate data correctness
  4. Record restore timing and gaps
  5. Only then execute production restore if required