Skip to content

Undoing a mistake from two hours ago

At 14:00 someone runs DELETE FROM students with no WHERE clause and commits. It is now 16:00, and normal traffic has continued since. The last full backup was at 02:00.

What restores the deleted rows without losing the last two hours of legitimate work?