Backups, Restores and Point-in-Time Recovery
A backup is only as good as your ability to restore from it. For a business, the real question is not 'do we have backups?' but 'how much data could we lose, and how quickly could we be back online?'.
This article explains the kinds of backup we run and what point-in-time recovery means for your peace of mind.
Two Numbers That Matter
- Recovery Point Objective (RPO): how much data, in time, you can afford to lose.
- Recovery Time Objective (RTO): how long you can afford to be down.
- Tighter targets cost more, so we agree sensible values with you.
Point-in-Time Recovery
Beyond nightly snapshots, point-in-time recovery lets us rewind the database to a precise moment — say, just before a faulty import ran. This is invaluable when the problem is not a crash but a mistake.
Testing Restores
We periodically restore backups into a safe environment to prove they work. An untested backup is a guess; a tested one is a guarantee.
Frequently Asked Questions
How often are backups taken?
Typically daily full backups plus continuous transaction logs for point-in-time recovery, tuned to your agreed RPO.
Where are backups stored?
In a separate location from the live database, so a single failure cannot take out both.
If you need a hand with any of this, your Progressive Robot delivery team is ready to help. Raise a ticket from the Support area of your client portal or speak to your account manager and we will guide you through the next steps.