Fieldnotes

Database backup retention

Keep daily backups for 30 days and monthly backups for one year. Choose a longer retention window when your recovery requirements call for it.

Decide what you need to recover

Backup retention is the length of time you keep a recovery copy before deleting it. Start with the longest period your team needs to recover from an accidental change.

Test a restore before deleting backups

Restore a backup to a separate database. Check that the tables and records are complete. Record the time the restore takes so your team knows what to expect during an incident.

Document your retention policy

Write down who owns the backup process, how long each copy is kept, and when a restore was last tested. Review the policy when your storage or recovery requirements change.

Written by the Fieldnotes engineering team.