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

In hours, with a decimal point (0.25 = 15 min).

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

  1. CSV header: system, tier, rpo_target_h, rto_target_h, backup_interval_h, restore_h (tier optional).
  2. Take targets from the business, interval and restore time from backup software and test restores.
  3. Press Calculate; download the gap table as CSV.

Fields

System CSV
In hours, with a decimal point (0.25 = 15 min).

Worked example

InputValue
System CSV
system,tier,rpo_target_h,rto_target_h,backup_interval_h,restore_h
ERP,1,1,4,24,6
Mail,1,4,8,4,3
Dosya,2,24,24,24,10
Web,3,24,48,24,2

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

InputValue
System CSV
system,tier,rpo_target_h,rto_target_h,backup_interval_h,restore_h
SQL,1,0.25,2,0.25,1.5
AD,1,24,2,24,0.5
CRM,2,12,8,24,12

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

Related service: Backup and Disaster Recovery

Systems online tools · See all online tools