Well, the FTP backup's log file says that the backup archive is indeed tiny:
DEBUG |20240612 14:42:04|Total size of backup archive (in bytes): 794321
That's 775.71 KiB. The reason is that you have set the site's root folder also as your output directory.
Exactly the same thing with the SFTP backup... which is for another site?
I have several remarks here.
1. When you are trying to troubleshoot you must keep everything the same except one and only one variable between runs. Otherwise, you cannot be sure which of the myriad of variables you changed had any effect, or if two or more changed variables combined in a way that you got the same effect for a different reason. Therefore, using many different sites to test one problem is a big no-no. Modify the configuration of the same site, only changing one thing at a time between runs.
2. Never set your backup output directory to coincide with a directory whose contents you want to back up. The backup output directory and all its contents (its files and subdirectories) are automatically excluded from the backup. This is a sanity feature. It prevents an infinite backup, where the backup engine tries to back up the increasingly bigger backup archive.
3. Never set your backup output directory to a site's root. Remember that Akeeba Backup will overwrite your .htaccess and web.config files in there, and add a blank index.html file to prevent web access. When you do that to a site's root, you will end up making that site inaccessible from the web!
4. You should build your backup process up, not try to do everything all at once. First, make sure that you can take a full site backup, stored locally. Then, configure its upload to a remote location and check it works. Finally, set up the automation. Note that this is exactly what I do with my own sites. Trying to do everything all at once is a recipe for trouble. It is only human to expect a problem in the last thing you configured; in your case, setting up the remote storage. In most cases the problem will have to do with a previous step of the setup, which is now out of mind. Doing one thing at a time and verifying it ensures that the first and last thing we did before having to troubleshoot is one and the same, i.e. we are far more likely to figure out what the root cause of our problem is. If no problem happens, yay! All the better :)
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!