The best way to back up a small or medium sized database is by creating a Database Maintenance Plan within SQL Server. This process will dump the contents of the database to a file on a scheduled basis. The Backup Client will then back up that file. You can schedule the dump within SQL Server to happen on a regular basis.
Each time you dump the database, it will overwrite the same file name. The Backup Client will then compare that file to the previous version stored at our secure data center. The Backup Client will then extract and transfer only the changed data since the last backup.
See Also: