1. Start SQLBackupAndFTP.
You can find the SQLBackupAndFTP shortcut in the Windows Start menu in the SQLBackupAndFTP folder.
2. Connect to an SQL Server.
The Сonnection form will open automatically.
SQL Server Name: enter the name of the SQL server you are connecting to (like \sqlexpress, sahdl0uze.database.windows.net,1433 or 127.0.0.1,1433).
Click Test Connection to verify the connection. If the connection fails, first use SQL Server Management Studio (SSMS) to connect to your database, and then use exactly the same settings in SQLBackupAndFTP.
3. Select databases to backup.
Click the gear button into the Select database section, to select databases to backup. In the opened window choose databases you want to backup checkboxes next to them in the list. Or you can check Backup all Non-System Databases - this will automatically select all non-system databases. This feature has an additional benefit - if new databases are created in the future, they will automatically be backed up. To exclude some databases from being automatically backed up add them to the Exclude databases list.
4. Select databases to backup.
Click the plus button to select destinations to store the backups.
Select one of the backup destinations where you would like to store the compressed backup files.
5. Set up notification e-mails.
Turn on Send e-mail confirmations.
On Success e-mail to (optional): e-mails will be sent to these recipients when the job is successful.
On Failure e-mail to: e-mails will be sent to these recipients if any error is encountered during the backup job.
On the E-mail Settings form you may specify how you want your emails to be sent. If you are using a paid version, emails will be sent through Automatic option (web service on SQLBackupAndFTP.com).
6. Run the job to test it.
Click Run Now. Verify the appropriate people have received email messages. Verify the target folders from Local/Network Folder or FTP server (if specified) contain a zip file for each database. If possible, test restoring these databases.
7. Schedule the backup job.