Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Availability Testing
A database that's unavailable isn't useful. The availability test is a simulation of the database restore process assuming the worst. The measurement is the time required to restore the most current production data to a test server and prove that the client applications work. This measure of time is normally referred to in the business as a recovery time objective (RTO). As an administrator it's important to establish with the business what the expected RTO is, that way in the case of disaster there is an established expectation for getting data systems accessible again. This agreement is typically formalized in the form of a service level agreement (SLA), which is a written agreement between the business and technical units.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access