Backup and Restore Procedures

[charlieroth]

Why

Protect against data loss and enable disaster recovery.

Definition of Done

• A script or documented commands back up the database and the index directory.
• Restore steps are tested against a fresh environment.
• Backups exclude transient tables like in‑flight jobs.
• Runbook includes schedules and retention guidance.

Tasks

• Write backup and restore commands.
• Test a full restore from scratch.
• Exclude transient data from backups.
• Document rotation and verification.