liveBook · Manning

Recovery time objective

As explained in 100 SQL Server Mistakes and How to Avoid Them

RTO, or recovery time objective, is the maximum acceptable duration of service downtime after a disruption.

Recovery time objective (RTO) defines the acceptable duration of downtime after a failure or disaster. It is a business requirement used to shape a database recovery strategy, not a default number to apply to every system. section 12.1 section 12.12

RTO differs from recovery point objective (RPO). RPO sets acceptable data loss; RTO sets acceptable outage time. A plan can meet one requirement while missing the other, so both must be agreed before choosing schedules, recovery models, or restore methods. section 12.1 section 12.12

Avoid the “one schedule fits all” mistake:

  • Ask the application owner what outage duration causes unacceptable business impact, rather than accepting “instant recovery” as an unexamined requirement. section 12.1
  • Compare the requested recovery time with the cost of redundant, geographically dispersed infrastructure. Very short recovery requirements may justify high availability and disaster recovery; lower-priority systems may reasonably use backup and restore. section 12.1
  • Set backup and recovery arrangements to the agreed RTO and RPO. A default schedule can either leave an application exposed or consume unnecessary backup storage and resources. section 12.1 section 12.12

A priority mismatch

A P4 application may not justify a highly available topology when its business impact permits recovery through backup and restore. Conversely, treating every database as though it can tolerate an hour of disruption can create a serious problem when its agreed limit is shorter. section 12.1 section 12.1

Recovery capability must be real, not assumed. Backup validation and a workable restore sequence support the recovery strategy; untested or failed backups can turn an apparently acceptable RTO into a prolonged outage. section 12.0 section 12.12

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines RTO, contrasts it with RPO, and relates both to scheduling and availability choices; defers high availability and disaster recovery details.
Examples
Uses a P4 application and a one-hour default backup schedule that conflicts with a shorter tolerated outage.
What it assumes
Introduces RTO and RPO from their business-impact questions without requiring deep SQL Server expertise.
What you can do after
Evaluate/understand whether backup–restore or a highly available topology matches an application's downtime requirement.
How it connects
Connects RTO to recovery point objective, backup schedules, backup–restore, high availability, and disaster recovery.

Also explained in

Compare how 3 books explain recovery time objective →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.