From your first backup to a successful restore.

You can find the SQLBackupAndFTP shortcut in the Windows Start menu in the SQLBackupAndFTP folder.

The Connect to Server form will open automatically or by clicking the gear button.

Select the DBMS type from the Server type list and set the connection parameters for the selected DBMS type.

Click Test Connection to verify the connection. If the connection succeeded, click Save & Close.

Click the gear button in the Select databases section and choose databases you want to backup by clicking 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.

Choose a destination on this screen to store the backups.

Turn on Send confirmation.

On success email to (optional): emails will be sent to these recipients when the job is successful.

On failure email to: emails will be sent to these recipients if any error is encountered during the backup job.

Click the gear button for Advanced email settings.

Click Run Now.

Verify that the appropriate people have received email messages.

Verify the target destinations contain backup files for each database.

If possible, test restoring these databases.

Turn on Schedule backups. Choose a time to do a full backup, usually during the night.

Click the gear button for Advanced schedule settings.

All your backups can be found at the History & restore section. You can open a backup log by clicking Open Log, download backup file(s) by clicking Download Backup or restore the database from the backup by clicking Restore from Backup.

Web log shows the read-only history of backup jobs from your computers. It is available for licenses with active Full-Service subscription.

More about Web log