The checkpoint operation does not create a backup of the database, the pages being copied into the main file will not be marked as checkpointed in the WAL until after the copy is successful (here's your atomic commit). If the copy process breaks for any then the pages written are ignored (as they still show up as uncheckpointed in the WAL) and can be recovered from the WAL later