Remove backup metadata when the backup fails

Deletes the leftover `physical_backup_meta.json` when a backup step fails, so a later `DROP DATABASE` cannot delete table files.