SQLBackupAndFTP Changelog

What's new in SQLBackupAndFTP 11.0.1 Beta

• Main Window:
• The main window is now divided into three sections: job list on the left, job execution history with restore on the right and job settings in the center.
• Job List:
• All backup jobs are now displayed in a single list as opposed to separate .jobx files for each job in previous versions. This allows you to manage all jobs in one screen instead of opening them one by one. The red exclamation mark to the left of job’s name indicates that the last backup has failed, while the green check mark indicates that everything went fine.
• Job History and Restore:
• When you select a job from the left panel you can see all its backups in the right panel. Moreover, there you can look at a detailed execution log, download or even restore the database from the selected backup wherever the backup is located. Previously you had to use a separate utility to restore backups, now you can restore your backups right from the application. This works with Full, Differential, and Transaction Log backups. They will be automatically downloaded from the destination folder, then unpacked, and restored on the database.
• Job Settings:
• In the middle panel you can see all backup job settings placed in step-by-step order. It makes the setup process easier especially for the new ones. Also, yellow tool tips guide you if you’re not sure what to do next.
• There are five main steps to follow: from connecting to SQL Server down to setting up email notifications. All other settings are optional and hidden under the “More settings…” link. So, there is no good old Advanced Settings dialog, all advanced settings are presented as job setup steps.
• You can either set up each step by clicking the blue gear icon or turn some functionality off and on using a switch. But, of course, not all of the steps are optional. For example, you can’t skip connection to SQL Server or database selection step.
• For those who prefer using “Backup all non-system databases” option, there is a surprise here. Now you can exclude some databases from being automatically backed up by adding them to the “Exclude databases” list.
• Backup Destinations:
• Backup destinations are the storages where SqlBackupAndFtp sends database backups to. The new version allows sending backups to Local or Network Folder, FTP server, Amazon S3, Dropbox, Google Drive, OneDrive and Azure Storage.
• We have excluded Box from the list of backup destinations (due to lack of demand) but added OneDrive for Business.
• SqlBackupAndFtp 11 makes it possible to choose what types of backup (Full, Diff, Tran Log or Folder) will be sent to the specified destination. Also, making a destination “Emergency” instructs the system to use it only if all other destinations failed.
• As you can see from this screenshot, the “Auto delete Diff and Tran log after” option were added. It allows you to control (separately from the full backups) how long your differential and transaction log backups are kept in the destination. This is useful when after some period of time you want to keep only full backups freeing some storage space.
• Backup Schedule:
• The new version contains practically the same options for backup scheduling as the old one except the new “Run between” option that allows you to specify a period of time when the database(s) will be backed up. This is useful if you want to create frequent backups, but only during, say, working hours in your company.
• Also, please take note that we have moved “Auto delete old Diff & Tran Log backups after a Full or Diff backup” option from the advanced backup schedule to destination settings window.
• Shared Temporary Folder:
• A temporary folder is a place where backups are created before they are sent to the destination. It is now shared among all the backup jobs on this computer.
• This releases you from keeping the temporary folder path updated in all backup jobs in case it has changed. Note that this setting is applied to all your jobs.
• Custom Scripts:
• In the new version, you can specify Windows batch file (*.cmd and *.bat) to be executed before or after the SQL backups. In the previous versions, only T-SQL scripts were accepted.
• Backup Options:
• Place backups for each database into its own subfolder – puts backups into subfolders named according to backed up databases instead of storing all backups in the root of the destination
• Backup one DB, send, repeat – sends each backup to the destination before starting the next database backup; useful if you have large databases
• Ignore offline databases – will not backup databases with offline status
• Import your legacy *.jobx files:
• When you migrate from the previous version of SqlBackupAndFtp, there is no need to create backup jobs anew. Just go to Tools > Import and get your job settings imported.