SQL Server database backup automation

I want to do:
Do SQL Server database backup automation

1) take database backup on schedule
zip database files,
take a fingerprint of the zip (perhaps as the same file)
transmit to another PC

2) at receiving PC:
check backup zip arrives
test the file integrity
send alarm message if it fails.

NOTE: Currently. On the database servers, backups are taken and sent by SqlBackupAndFtp (free version) but the process is not monitored and I suspect failure messages are not even sent.

QUESTION:
3.1) Is there Linux software which does the 2nd job (2), at the receiving end. For several backups, arriving from several servers?
3.2) Or does anyone have links to blogs which describe examples of this process scripted?

Is this homework? If so, tell us what you have tried.

Also, do you have physical access to the server or is it running on a hosting service somewhere?

I'll go a little further. If you have physical access to the server, write a script to dump the database, then call the script via a cron job. (If this is homework, that ought to point you in a good direction to get started.)

Assuming this is MySQL and not MSSQL (since we are on LQ)
This can be easily done with:
- mysqldump then zip
- md5sum for integrity check
- rsync / sftp to copy to another machine
You should be able to find plenty of examples of above with your favorite Internet search engine
-----
And, if you are not comfortable with above, have you looked at this: https://sqlbackupandftp.com/blog/weblog

To frankbell:

I've tried nothing yet. Given you recommended no Linux software, I'll assume you think it's best done with scripts. Would you use bash for this or do you recommend I try a more modern scripting language?

I have physical access to none of these servers. I can get in to the Linux server via PuTTY with the root account. Access to the Windows servers is not so easy.

We already use the free version of SqlBackupAndFtp. But the alarm messages are only available in the paid version. See: https://sqlbackupandftp.com/blog/service-down-alerts. I could have a basic alert service if we upgrade to a paid version.

To dc.901:

They are windows MSSQL database servers. I want to collect all the backups on one Linux server. Then check those backups arrived in healthy state.

I'm not sure I need to use an MD5Sum check. 7zip has a "test archive" feature which tells you whether the archive is good. This will be a more comprehensive check.

Back Up and Restore of SQL Server Databases

"Healthy State"?
Recovery Models?
Full
Partial
Differential
Copy Only
Transaction Logs
Possible Media Errors

What is your current backup and restore procedure?

When I did something like this many years ago, I did it in bash and it worked like a charm. I also learned a lot.