Every now and then I come across an application or utility that I think is amazing. Doesn’t have to have an all singing, all dancing interface, but do something really well.
SQLBackupAndFTP is one of those programs. There are a couple of really cool things about this package. Firstly is the price, it’s affordable and well worth its weight in USB keys. Only $69 for a professional licence, or $149 for a lifetime license. Anyone who needs to back-up their SQL server on a schedule basis (and let’s face it, who doesn’t need to) should be using this package.
It’s easy and quick to setup,
The schedule function just works. Once you have configured your destinations, it really is just set and forget. Everyday an email pops into the inbox advising the success (or failure) of the scheduled backup. I prefer to send multiple destinations, both on the local file system and remote FTP. The program has support for Local/Network, FTP, Dropbox, Google Drive and Amazon.
But wait, there’s more…
As part of the installation is the One-Click SQL Restore tool. Now this is cool. When we need to look at clients data, it quite literally is a one click process. I just point the program to a zip copy of the .bak file (which was produced automatically from SQLBackupAndFTP) and whomp, it gets restored. No hassles, no messy dialogs. If you need more options and control, it’s all there under the hood waiting.
ANYONE who has a SQL database that requires backup (read: ANYONE who has a SQL database) should be using this product.