Getting Paranoid about Backups

[killdozer (Brutalise me with music)]

The solution to DB corruption

Here’s a question/test I’d like to know the answer to. If you have a DB backup that 880 feels is corrupt, can it be restored using the previous version still? Put another way is the DB unusable OR is 880 fussier. Regarding backups, if you don’t actually test a restore from one then it’s not worth the name. Lost count of the times I’ve gone to support, at various orgs, for recovery from backup to find that something’s not working properly and the backups are hosed. Edit: If you work somewhere a…

@killdozer

While it’s not a solution to corruption a good backup strategy helps. Rather than have a single schedule, multiple schedules/locations and strategic retention can work well. Something like:

• Every day and keep 3
• Every 2 days and keep 3
• Every week and keep 3
• Every month and keep 5
• Every 6 months and keep 2
• Every year and keep 5

This keeps plenty of recent backups in different places and you retain a long, sparse tail should the worst happen.

At the risk of repeating myself, I won’t quite…