3 ms·
Worst case in 2021 should be a daily full backup + transaction logs. That's enough to get you point in time recovery. On AWS, EBS snapshots are incremental (I
by raffraffraff 5y ago
Worst case in 2021 should be a daily full backup + transaction logs. That's enough to get you point in time recovery.
On AWS, EBS snapshots are incremental (I didn't know that until studying for AWS certification), so you could schedule a snapshot every 5 minutes if you wanted.
Looking at the timeline, I'm just gonna repeat something I said in another thread this week: it's easy to underestimate how long it takes to do basically anything with a few hundred GB of important data.
- Aeolun 5y agoFound this out recently when my 250GB database had to roll back a transaction and was stuck for hours :/ Restoring a new database from the AWS snapshot and transaction logs was literally faster.