No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss and availability when it comes to planning for disasters—Recovery Point Objective and Recovery Time Objective. In this episode, we touch on how you might come up with these metrics, how to consider the implementation cost, and how you might go about walking through a disaster situation to test your plan.
The show notes and video can be found at https://sqldatapartners.com/2021/08/04/episode-230-rto-rpo. Have fun on the SQL Trail!