There are many ways to automatically backup MS SQL Server databases even if you use an Express version and do not have SQL Agent installed.
I sketched one possible solution some time ago, calling T-SQL commands from a batch file which is executed as a Scheduled Task.
If you are running MySQL databases under Linux, you may be aware of a tool called automysqlbackup, which runs as a cron job, creates dumps of MySQL databases and rotates daily and weekly backups.
During the last couple of days I translated this script into PowerShell to backup MS SQL Server databases in a similar way.
automssqlbackup provides the following functionality:
- Local or Remote backup
- Rotation of daily and weekly backups
- Optionally zipping backups
- Notifications by e-mail
The first release of automssqlbackup is version 0.25 to reflect the current version 2.5 of automysqlbackup, which it is based on.
automssqlbackup is available for download here.