What backup software to choose for the ability to send via FTP and / or cloud, as well as compression, encryption?

Question

Backup

1) I mainly need to copy 1C databases (file, MSSQLServer, Postgre_SQL) so far only on Windows.
2) Here, once at a time, copy arbitrary files except for databases, for example, documents.
3) Make an image of the system here.

Basically, the requirements that I place on the software are:
- copying to local media
- copying to network media
- Copying to ftp
- copying to the cloud
- cleaning up old copies by time / quantity / other
- copying file, SQL IB 1C
- message via mail about the success / failure of backup completion
- copying ordinary data, documents for example
- compression and archiving
- encryption
- the ability to set up a schedule
- run as a service
- opensource / freeware / -
centralized management, including remote offices (white IP is available)

Based on this, I have already sketched an approximate list of software, I immediately describe the shortcomings of the software that I found:
- effector saver - free version will soon cease to exist after correspondence with the developers
- 1C updater - when transferring the updater with another motherboard or process, you need to buy again, because there is no normal licensing from the developer
- cobian backup - could not get the centralized management "remote access server" to work, the hands are crooked / unfinished by the developers. The software has not been updated since 2012. It is not clear how to back up SQL versions, it is clear that you need to use the built-in DBMS tools, but then the question is how to track new files. For example, through maintenance plans, MSSQLSErver made a backup, how cobian will track exactly this new file, archive it and send it to the repository accordingly, that is, so that cobian would only archive the new file and not the earlier ones. No cloud support. I looked at cobian the most, if we forget about the clouds.
- sqlbackupandftp - free edition is very limited, only 2 DBs
- Microsoft SQL Server maintenance plans - I couldn't get DBMail to work when I tested it. The second point is that in order to send somewhere other than locally and a network resource, for example, FTP / cloud, you need to use other software, because, as far as I understand, MSSQL cannot send backups to FTP.
-pg_dump is an extremely inconvenient thing: it works through the scheduler with batch files, there is no encryption, no compression (at least I didn’t find it), there is no way to send it to the mail to check it, only the OS log - you need to climb onto the server and see how it was executed there looking in scheduler logs.
- postgresql backup - as far as I understand the software is approximately the same as sqlbackupandftp, the developers seem to be the same, with the only difference that this software is only on postgresql
- microolap pago dump - I have not yet figured out what kind of software, it is only sharpened for postgresql
- handy backup - the version that suits me is expensive, 7400 rubles
- acronis / EMC / other foreign paid systems - I do not consider, there are reasons to explain here it is not possible
From I used all this software: effector saver, 1c updater, SQL plans, pg_dump, cobian, sqlbackupandftp.

Clouds, either cloud or ftp will be used:
Of the free clouds, the maximum amount that is at least approximately suitable is only mega.nz - 50GB. The question is in which cloud you can set the option to synchronize either the last N files from the directory on your computer, or for the last N days, otherwise the actual data will simply not be synchronized to the cloud due to the cloud space being busy, and new copies will only be stored locally, but not in the cloud.

Of the individual options, I also came across bacula / bareos, but as far as I understood the system, it takes a long time to master and configure it tediously.

For a backup copy of the system disk, I used only a one-time copy of "Windows archiving" before, the problem is if you set to make copies constantly through it, this system does not know how to clean up old copies, and accordingly it will score the disk to zero. Here, from what I previously sketched: Aomei backupper, EASEUS todo backup, paragon backup free, macrium free, iperiusbackup.

I understand that the question is voluminous, if anything I will already ask questions on individual points, when the situation becomes clear for me based on what I have thrown.

Answer 1

Of the individual options, I also came across bacula / bareos, but as far as I understood the system, it takes a long time to master and configure it tediously.

Do not want to pay money - sit and master the configuration. Do not want to understand the configuration - pay for the finished product. Optional: hire an admin.
upd :
you want a lot right out of the box and for free. This does not happen - you pay either with money or with your time (which is also money, employer or yours)

Answer 2

Join Dmitry - You want too much. There are not so many successful large OSS projects in the world that implement this or that functionality - they all have their jambs, but people put up with it, because there is no alternative. Before you look for something "for free" and with such a wagon of features - think about who needs to write it, test it, debug it, analyze user complaints?
There is practically no support for FTP in projects - FTP is not the easiest protocol to set up, it works mainly where the bolt is put on protection. 1C is a purely Russian reality, by demanding something compatible with it, you immediately cut off all non-Russian manufacturers.
I think you will have to collective farm your own project.

Answer 3

You want a lot, and this is basically normal.
But you need to understand that everything you want right out of the box, and even for free, you simply will not find.
As a result, we write scripts using either regular system methods - ntbackup, or third-party components that have an API.
Well, for example, a system image - as a rule, it does not need to be done every day.
You make an image with a script, and copy it to a network share. As a rule, it makes little sense to pour it into the cloud.
SQL databases - using a script, make a backup using the DBMS, send the resulting backup file with the same script to a network share.
If you need to send to the cloud, there are a lot of console utilities that can work with ftp, sftp, with the mega.nz cloud, etc. Set up the utility in the scheduler.
If you need it centrally - everything is the same, but using some kind of ready-made mechanism for centralized management like bacula
With 1c there is no special specifics -
SQL databases are backed up by means of the DBMS - further as regular files.
File bases - a shadow copy is made so as not to expel people from the base, and is quietly packed into an archive, and poisoned where necessary.

- the ability to configure the schedule
- run as a service

Banal windows task scheduler - works as a service, shove everything you need into the scheduler and it will start it all on time.

compression and archiving

banal archivers - winrar, 7z, deduplicators like zpaq, everything starts perfectly from a batch file or a script.

message via mail about success/failure of backup completion

Sending logs to the mail is available in most backup systems, and there are no problems sending mail from the command line.
Moreover, if you have a centralized place, it is better to send a message about success to the central server, and it will send a message to you if the message about success has not arrived in time.

Answer 4

Effector Saver and other options for 1C - paid for
free - scripts and other options