A backup is an immutable snapshot by design, and deleting one row from one is either impossible or defeats the purpose of having it. The third option is…
A backup job that reports success proves that a file was written, which is a different claim from the data being recoverable. Measuring the recovery time objective rather…
A nightly backup restores to midnight, and recovering to the moment before a bad migration needs the binary logs since then. The retention setting is the one that…
A full restore of a 180 GB database to fix one table is hours of downtime for a problem affecting forty thousand rows. The transportable tablespace route is…
The append-only file rewrite used to fork the process and rewrite everything into one file, which doubled memory at the worst possible moment. The fork-and-copy behaviour was the…