6 Answers
6

Is there a reason that you want a special tool for this instead of setting up scheduled maintenance jobs in SQL Server Agent? What are your requirements?

I recommend the scripts from Ola Hallengren that is free to use as a way to set up basic backup solution. It sets up the SQL Agent jobs, the only thing you have to do is enable and schedule when and what of the backup jobs you want to run. It writes the backups to your default backup directory, so be sure to change the parameter in the jobs if this is not your intended destination.

Use a tool like Symantec BackupExec to compress the backups to a central location, another option is Red Gate's SQL Backup tool that does compression. The other option is as others have said is to do a backup directly in SQL, but unless you have enterprise, it won't compress the data.