Backup and Disaster Recovery · #58
Online RPO and RTO Gap Matrix
Compares target and actual RPO/RTO per system and lists the gaps.
- Data is processed in your browser and not sent to a server
- Export: CSV
Tool
What does this tool do?
Business units say 'at most 1 hour of data loss, back within 4 hours', while backup runs once a night and a restore takes 6 hours. If this gap is discovered only during an incident, the continuity plan fails. The matrix puts each system's target, the real RPO from the backup interval and the measured restore time side by side.
How to use it
- CSV header:
system, tier, rpo_target_h, rto_target_h, backup_interval_h, restore_h(tier optional). - Take targets from the business, interval and restore time from backup software and test restores.
- Press Calculate; download the gap table as CSV.
Fields
- System CSV
- In hours, with a decimal point (0.25 = 15 min).
Worked example
| Input | Value |
|---|---|
| System CSV | |
Expected result: ERP has a 23-hour RPO gap and a 2-hour RTO gap; Mail, file server and web meet their targets.
ERP needs hourly log/incremental backups or replication instead of daily backups; a 6-hour restore can be shortened with instant recovery. Whether the target is realistic should also be discussed with the business.
Second scenario
| Input | Value |
|---|---|
| System CSV | |
Expected result: SQL and AD meet their targets; CRM has a 12-hour RPO gap and a 4-hour RTO gap.
Method and assumptions
Actual RPO is taken as the backup interval in the worst case (incident just before the next backup). Actual RTO is the measured restore time. Gap = actual − target; positive means red.
Using the result and troubleshooting
Prioritize gaps by business impact (tier 1 first). Validate restore time with the Restore Time tool and the interval with the Backup Window tool.
Limits and common mistakes
- Backup job duration and replication lag are not added to RPO; sequential startup of dependent systems is not added to RTO.
Frequently asked questions
What is the difference between RPO and RTO?
RPO is the maximum acceptable data loss (looking back), RTO the allowed time until the service runs again (looking forward).
Related tools and service
- Restore Time CalculatorCalculates how long a restore takes and whether it fits the RTO.
- 3-2-1-1-0 Backup Rule CheckerAudits each system's backup copies against the five conditions of the 3-2-1-1-0 rule.
Related service: Backup and Disaster Recovery