Backup and Restore Procedures #45
Description
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.