There are three common ways to schedule SQL Server backups on a small server: SQL Server Agent maintenance plans, hand-written scripts run by Windows Task Scheduler, or dedicated backup software such as Velocity. Each is a reasonable choice for someone. Here is where each fits.
Side by side
| Agent maintenance plan | Scripts + Task Scheduler | Velocity | |
|---|---|---|---|
| Works on SQL Server Express | No (no SQL Agent) | Yes | Yes |
| Cost | Included with Standard and Enterprise | Free | Paid licence per computer, free trial |
| Setup | Wizard in SSMS | Write and test scripts yourself | Backup job wizard in the app |
| Off-site copy (FTP, Google Drive) | Not built in. Needs extra steps. | Separate script (WinSCP, rclone) | Built-in destinations |
| File and folder backup | No | Separate script (robocopy) | Yes, same app |
| Retry on failure | Job step retry settings | Only if you script it | Automatic retry delay sequence |
| Email after a run | Via Database Mail + operators | Only if you script it | Built in |
| Restore without overwriting live database | Manual, in SSMS | Manual, in T-SQL | Restores under a date-stamped name when the name exists |
| Who maintains it | Whoever knows SQL Agent | Whoever wrote the scripts | The vendor, via updates |
Choose maintenance plans when
You run Standard or Enterprise edition, have a DBA or IT person comfortable with SQL Agent and Database Mail, and your off-site copy is handled by something else, such as a NAS replication or an existing server backup product.
Choose scripts when
You are on Express, comfortable with T-SQL, batch and PowerShell, and have time to maintain them. Scripts are free and fully flexible. The cost is maintenance and silent failures: credentials change, a path moves, an upload stops, and nobody notices until a restore is needed. Our SQL Server Express scheduling guide and script generator get you most of the way.
Choose Velocity when
You want SQL Server databases and folders backed up to local plus off-site destinations from one place, with retries and email reports, without maintaining scripts. It fits small businesses without a full-time DBA, and IT partners looking after several client servers, where each server runs its own licensed copy.
What none of them do for you
No tool removes the need to test restores, check backups are recent, and keep an off-site copy under separate credentials. Whichever you choose, put those three on the calendar.
Try Velocity on your server
Install the trial, create one backup job for a database and one for a folder, and send them to a local folder and Google Drive or FTP/FTPS. That is usually enough to decide.