How to setup SQL Auto Backup using SqlBackupAndFtp

In this post, we will show you how easy it is to setup SQL auto backup using SQLBackupAndFTP
After you downloaded and installed SQLBackupAndFTP there are just a few steps to take.

1) Connect to SQL Server

The connection window will be opened automatically. You need to specify your SQL Server credentials and press “Test SQL Connection” to check the connection. Then click “Save & Close” to save the connection.sql auto backup - Connect to SQL Server

2) Select databases

Click the gear button in “Selected Databases” section and select all databases you want to backup. Alternatively, you can select “Backup all non-system databases” if you want SqlBackupAndFtp to backup all databases including those that will be added in the future. If you need to exclude some databases from such “automatic” backup, add their names in the box below the list.

sql auto backup - Select databases

3) Choose backup destination

Now you need to select a place where the application will send SQL Server database backups. Just click the plus button in the “Store backups in selected destinations” section and select a destination place from the list.

sql auto backup - Select where to store the backups

That’s it, now you can run the backup job!

Your SQLBackupAndFTP backup job is ready, but to automate this job, you have to take another two simple steps:

1) Schedule SQL auto backup

Turn on “Schedule backups”  to create a backup schedule. If you need fine tuning of the schedule click on the gear button next to the switch. sql auto backup - Schedule backups

2) Email notifications

Now you can tell SqlBackupAadFtp to send you an email after a successful backup or if something goes wrong . Go to the “Send email confirmation” section and specify the email addresses in the corresponding text boxes.sql auto backup - Set up email confimations

Your SQL auto backup is ready!

Actually, this is the simplest scenario. There are much more options in SQLBackupAndFtp to customize SQL auto backup. Such as backup compression and encryption, custom SQL scripts and even folder backup. You can find those options if you click the “More settings” link at the bottom.

[Total: 2    Average: 5/5]

Leave a Reply

Your email address will not be published.