Disaster Recovery in
SQL Server

Specific operational goals of implementing recovery point objectives / recovery time objectives

§  As such RPO and RTO are key metrics for measuring recovery time and data characteristics. Other supplementary metrics include:

1.     Recovery Time Granularity (RTG) determines the time spacing between recovery points; whereas RPO is the last recovery point prior to a failure, RTG defines recovery point selection options prior to that recovery point.

2.     Recovery Object Granularity (ROG) expresses the level of objects that a recovery solution is capable of recovering. For instance, object granularity may be a storage volume, a file system, a database table, a database row / column / field, a transaction, a mailbox, an email message, etc.

3.     Recovery Event Granularity (REG) measures the ability of a recovery solution to track events and to recover an application or data to a specific event.

4.     Recovery Consistency Characteristics (RCC) measures the usability of recovered data by the associated application.

5.     Recovery Location Scope (RLS) defines where the protected data must be stored when recovery takes place (i.e., locally, remotely, on which media / storage tier).

6.     Recovery Service Scalability (RSS) measures the number of applications or data sets the recovery solution handles, and the maximum size of the data it can store.

7.     The Maintenance Point Objective (MPO) describes the maximum allowable window for the performing scheduled system maintenance

                        Please  find the below PPT  link:

https://docs.google.com/viewer?a=v&pid=sites&srcid=ZGVmYXVsdGRvbWFpbnxzYWlmc3Fsc2VydmVycmVjaXBlc3xneDo2NjU5ZTAwZDEwYjlhYWYy