Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Thursday, 11 November 2010

Recovery Markers for Business Continuity

In every disaster recovery plan for SQL Server it should have specified the key goals. The goals that should be recorded are the Recovery Point Objective and Recovery Time Objective.

The Recovery Point Objective (RPO) is the amount of acceptable data loss specified within your contractual obligations.

The Recovery Time Objective (RTO) is the amount of time the service can be unavailable after a disaster.

Example

RPO - 5 minutes of data loss only
RTO - 1 hour before service needs to be restored

Backup Process

A backup and recovery process should be put in place to backup the databases and backups should be regularly restored to test the validity of the backup process.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.