SqlBackupAndFtp 11 is significantly different from the previous versions – see the detailed post on what is new in v11. Here you can get a birds eye view on what is new and what is missing in the new version.
You can use the following buttons to filter the list.
|Schedule a backup job with Windows Scheduler
It was less reliable than scheduling using SBF service. Not needed.
|Full, Diff and TranLog backup schedule||Yes||Yes|
|Business days for a backup schedule||Yes||Yes|
|Business time for a backup schedule||No||Yes|
|Backup a database into .bak file||Yes||Yes|
|Backup Azure SQL database||Yes||Yes|
|Remote backup into SQL script
Remote scripting is not sufficiently reliable way to backup SQL Server.
|Exclude a database from a backup job||No||Yes|
|Copy Only database backups||Yes||Yes|
|Auto restore from Full, Diff & TranLog backups
Select any of the backups, press button Restore and all log chain will be restored automatically for you
|Restore Azure SQL database
As simple as pressing the Restore button
|Download a backup file
The feature is built-in now, just press the Download button on any of the backups
|Exec a SQL script before or after backup||Yes||Yes|
|Exec a Windows batch script before or after backup||No||Yes|
|Send email notification for backup jobs||Yes||Yes|
The service to see backup results on the web has not been offered for a while. For older clients the service was limited to 1 year and has expired now. Very soon it will be replaced with a new service. If you need this feature now – look into SqlBak.com
|Place the backups for each database into its own subfolder||Yes||Yes|
|Ignore Offline databases
Useful when you chose to backup all databases and don’t want to get error messages if offline database can not be backed up
|Backup one DB, send, repeat
This option can be chosen instead of backup all, send all
|Use a common temporary folder for all backup jobs||No||Yes|
|Use a specific temporary folder for a backup job
This setting is now shared across all jobs
|Zip or 7-zip compression||Yes||Yes|
|Verify after backup||Yes||Yes|
|Use emergency destination
Option to send backup to this destination if all other destinations fail
|FTP destination. “Write FTP session to log” option||Yes||No|
|Amazon S3 destination||Yes||Yes|
We plan to add it later. For now use v10 if you need it.
|Google Drive destination||Yes||Yes|
|Azure Storage destination||Yes||Yes|
|OneDrive for Business destintion||No||Yes|
|Save a backup job into a .jobx file
Job configuration is stored differently now. There is no need for separate files any longer.
|Load a backup job from a .jobx file||Yes||Yes|
Seamless update so you could always use the version with the latest security and destination API changes