Point-in-Time Recovery
The hard part is not replaying the log. It is knowing which second to stop at, when the bug has been quietly corrupting rows for a month.
The hard part is not replaying the log. It is knowing which second to stop at, when the bug has been quietly corrupting rows for a month.
In 2011 Google restored Gmail from tape within hours of its own estimate. Being able to produce that estimate was itself the product of rehearsal.
Soft deletion can recover covered deletion mistakes within its retention window. Tested backups cover additional failures; choose retention from detection needs and applicable obligations.
Nobody wants backups; they want restores. And the costliest topology still needs them, because running everywhere means the corruption runs everywhere.
A replica copies corruption and a restore needs more than files. Learn restore dependencies, corruption recovery, drills, billing units, and how to weigh reliability against cost.
Recovery is a claim until it has been exercised. This article covers incident roles, runbooks, containment, RTO and RPO, restore tests, and analysis.