Tuesday, 9 June 2015

What is RTO ? and RPO


RTO = Recovery Time object If a database server just died. Time needed to bring it up and running again? If the it is 1 hour then recovery time objective is 1 hour



RPO = Recovery point object –if there is data corruption, Data loss or unavailability, at what point in time can a valid copy of the data be restored from ? It’s usually measured as minutes, hours, days and weeks

at

1 comment:

  1. Israel Natural Gas26 July 2017 at 06:57

    Good one! I am searching for RTO and RPO. Required more information about RTO and RPO. Thanks for sharing.

    ReplyDelete

Subscribe to: Post Comments (Atom)

How to find table row count?

--Use below query to find table row count select so.name,sp.rows from sys.objects so inner join sys.partitions sp on so.object_id = sp.obj...