Backup and restore testing
A crucial part of destructive testing is ensuring your backups can restore your system correctly. Your backups are worthless until they’ve been tried in practice. This is a significant operation and highly disruptive, so as with all destructive testing, you’ll need a dedicated test environment for it. The following is a checklist of tests to run around backup and restore:
- Is the system fully functional during backups?
- Are there different types of backups you can restore from?
- Partial or full backups
- Different database systems
- Streaming replication versus from one point in time
- How long do backup and restore operations take?
- Is there a warning if taking a backup is disrupted?
- Ensure you can restore from all backup types
- When restoring from a backup, is everything replaced?
- Are any manual steps required when restoring from a backup?
Taking a backup can be a disruptive operation in itself since it involves database...
