What is the best software that can backup mysql and ms sql databases automatically?
Thanks
Definitely (for linux) automysqlbackup
from http://sourceforge.net/projects/automysqlbackup/.
For windows mysql server you can use the scheduled backup tool from mysql administrator application.
For MS SQL I use SQL script executed from scheduled tasks. Here is a good one.
To upload automatically remotely (from windows) on a FTP server you can use Fling.
Any of the Enterprise backup applications can handle this. Legato, CommVault, Backup Exec, etc. They can backup MySQL, MSSQL, Windows, Linux, etc. All it takes it buying the correct plugins.
For MySQL, I wrote a shell script to weekly full backup and daily incremental backup to a FTP server.
PS: Can you define "best"?
For MSSQL, a SQL Agent job can do that for you. It's built right into the SQL Server installation.