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.