The “Express” version of Microsoft’s SQL Server comes with limits, such as 10GB max database. But since it is free, for many small businesses and small database requirements, it fits the bill.
One thing lacking is the ability to do scheduled full and incremental backups of the database.
I’ve used a tool that one of my MVP buddies recommended to me several years ago called Sql Backup And Ftp.
It is one of the easiest utilities to install and setup that I’ve encountered. It comes in both a free and paid version – with the free version limited to backing up a maximum of two SQL databases. The utility allows you to direct backups to a network folder, or to a remote server via FTP, or to a cloud service location, such as OneDrive, DropBox and others.
Give it a try!
Here’s a screen shot of the log of a backup using this utility:
Leave a Reply