Hacker News new | ask | show | jobs
by ikyriakidis 1475 days ago
This could happen to almost everyone and maybe its time to review that backup-restore process to take into account restoring individual tables.
1 comments

Absolutely. Having done this blind and also with a well documented process I can say the latter is far smoother.

The restore process should be written in an incident response run book and practiced by the on-call people. (Maybe in your quarterly disaster recovery tests?) The terror of data loss fades significantly when you come across a clean, one page restore process and you’re able to get the data back without a lot of effort.