Hm, I believe that we are talking about different things.
When the backup begins, the backup archive is created with a .j01 extension in the backup output folder of your site. This is NOT a temporary file, it's the actual backup archive and it is NOT uploaded to your Dropbox.
If the entire backup archive fits inside a single part, the file is renamed to .jpa. Then and only then is it uploaded to Dropbox. In this case (entire backup fits in a single part) there is no .j01 upload.
If the backup does NOT fit inside a single part and one or more additional parts are required what happens next depends on your settings.
If you have enabled the "Process each part immediately" option the .j01 file is NOT uploaded yet. The reason is that the first 19 bytes of the file are the JPA file header which contain the number of part files the backup archive consists of, a detail we cannot know until the backup finished. So this part stays on your server. The next part is created with a .j02 extension. If a third part is needed the .j02 file is uploaded to Dropbox (that's the first file being uploaded to Dropbox!) and then we create the .j03 file. And so on and so forth until the backup is complete. When the backup is complete, the current part file (e.g. the .j03) is renamed to .jpa before being uploaded to Dropbox. Finally, the .j01 file's header is updated and then uploaded to Dropbox. Therefore the upload order of the files in this case is .j02, .j03, ..., .jpa, .j01. The files are uploaded in order except the first part which is uploaded last. None of them is a temporary file, they are all part files of the same backup set.
If you have NOT enabled the "Process each part immediately" option we continue creating the next part file .j02 in the backup output directory. And so on and so forth until the backup is complete. When the backup is complete, the current part file (e.g. the .j03) is renamed to .jpa. Then the .j01 file's header is updated. At this point the post-processing steps begin. Midway through the post-processing steps we have the upload to Dropbox. The files are uploaded in the order they were created: .j01, .j02, .j03, ..., .jpa. None of them is a temporary file, they are all part files of the same backup set.
There is no way that Akeeba Backup uploads a "temporary" .j01 file to Dropbox and then makes it disappear because a. .j01 etc files are not temporary and b. the upload code cannot possibly kick in until the backup part is finalized.
HOWEVER if your backup output directory is synchronized to Dropbox EXTERNALLY (not by Akeeba Backup but by the Dropbox agent running on your server computer) then You Are Doing It Wrong :) The backup output directory is also used as a temporary area. This is where we write the SQL files before putting them to the backup archive. This is where the backup archives (all their parts) are written while the backup is in progress. The fact that the archive has a .j01 extension before being renamed to .jpa is actually irrelevant and happens purely out of necessity (you cannot know how many part files you need before you take the backup, obviously). Well, if that's the case you should have a backup output directory outside the Dropbox synchronization root. But I think that's an overkill and completely unnecessary since we don't delete and create afresh the backup archive. We simply rename .j01 to .jpa which means that Dropbox uploads less than 1KB of command data to effect the rename. It does not re-upload the entire backup archive. Dropbox is very smart. I can swear that what I described is accurate, I have tried it with massive files (7GB exported virtual machines over a 512KBps shared ADSL uplink; the file rename took seconds, not hours).
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!