I'm looking for a solution to backup our websites and MySQL databases on a Windows Server 2008. Our current host does a full weekly and daily differential backups, but I would like to maintain my own set of backups as an extra precaution.
We do have MySQL administrator to back up the databases. I also have 7zip installed to compress files on the server.
I'm thinking of doing a combination of backing up the databases using MySQL administrator, then zipping the files (database and websites) to a backup directory on the server, and then downloading all to our office server via FTP. I would also have a process to delete the backup zip files off the server as well.
I'm thinking of backing up the websites weekly and databases daily.
I was hoping there might be a program (free or paid) that already does this. Any suggestions?