June 19, 2018 at 3:55 am
Hai all,
kindly please help me..
I want to know RTO and RPO timing on databases.
what is the syntax?
June 19, 2018 at 4:12 am
Recovery Time Objective - How much downtime is acceptable. Example, the company will not lose money before 2/4/8 hrs of downtime, or they will lose money from the 1st minute.
Recovery Point Objective - What is an acceptable recovery point, and data loss. Example, the company can tolerate losing 1hrs data, so a good recover point would be 1hr prior to the incident or disaster, or they can only tolerate 5mins total data loss.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 19, 2018 at 4:45 am
They're both defined locally. The Recovery Time Objective is how long it takes to recover your database. You have to test it. Recover just a database. Recover a database plus differentials. Recover a database, differentials and the logs to a point in time. How long do those take locally for your data. That's the Recovery Time. The Objective is a maximum amount of time to get the recovery done.
Recovery point objective is all about what type and how many backups do you have with the idea that some amount of data loss is possible. What is the minimum acceptable? 5 minutes? 10 minutes? 3 days? That then gets translated to the number and type of backups you do.
There is not a syntax to get this. It's about measuring and communicating with the business.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply