Detailed tutorial on how to setup SQLBackupAndFTP


This is a very detailed tutorial. For most users it would probably be sufficient to go through titles and go into details only when something is unclear.

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.
More details to —Āonnect to Azure SQL Database.

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.

4a. Send backups to a Local/Network folder (optional)


If you chose to send backups to a "Local/Network Folder" then you will see this form.

You need to store the backup on a different physical drive than your databases reside or (better) on another computer. Choose the target folder (like \\backupserver\sqlbackups\or D:\backups). Note that the account which starts a scheduled job must have sufficient rights to write to the target folder (In Advanced settings you can set it to run under your own account).

4b. Send Backups to FTP (optional)


If you chose to send backups to "FTP Server" - you will see this form.

On the FTP Server form specify how to connect to your FTP server. Like in any FTP client, you usually need to specify hostname, username and password. If FTP does not work for some reason, use any FTP client to connect to your server first, and then use the same settings here.

4c. Send Backups to Dropbox (optional)


If you chose to send backups to "Dropbox" - you will see this form.

On the Dropbox Settings form you'll need to authorize the SQLBackupAndFTP application to access your Dropbox (only once). Click Authorize... button to open the Dropbox site in your browser, sign in to your Dropbox account and click Allow. After that return to SQLBackupAndFTP and click Finish.

Important! The backups will be stored in \Apps\mySqlBackupFtp\folder in your Dropbox.

4d. Send Backups to Amazon S3 (optional)


If you chose to send backups to a "Amazon S3" then you will see this form.

On the Amazon S3 Settings form you'll need to specify how to connect to your Amazon S3 account. Access Key and Secret Key can be found on Security Credentials page of your Amazon Web Services account. It is recommended that you create a separate bucket for your backups. You can create it on Amazon web site (in any region) or SQLBackupAndFTP will create it in US Standard region.

4e. Send Backups to Google Drive (optional)


If you selected to send backups to "Google Drive" - you will see this form.

On the Google Drive Settings form you'll need to authorize SQLBackupAndFTP to access your Google Drive. Click Authorize... to open Google authorization page in your browser, sign in your to Google account and click at Allow. On the next page you will see the field with authorization code. Copy it to the clipboard.

After that return to SQLBackupAndFTP, paste the authorization code and click OK.

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

4f. Send Backups to OneDrive (optional)


If you selected to send backups to "OneDrive" - you will see this form.

On the OneDrive Settings form you'll need to authorize SQLBackupAndFTP to access your OneDrive. Click Authorize... to open OneDrive authorization page in your browser, sign in your to OneDrive account and click at Allow. On the next page you will see the field with authorization code. Copy it to the clipboard.

After that return to SQLBackupAndFTP, paste the authorization code and click OK.

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

4g. Send Backups to Azure Storage (optional)


If you selected to send backups to "Azure Storage" - you will see this form.

On the Azure Storage Settings form you'll need to specify how to connect to your Windows Azure Storage account. Account Name and Access Key can be found on Storage page of your Windows Azure Portal. Here you should enter Container Name for your backups. SQLBackupAndFTP will create containter if it does not exist.

4h. Send Backups to OneDrive (optional)


If you selected to send backups to "OneDrive for Business" - you will see this form.

On the OneDrive for Business Settings form you'll need to authorize SQLBackupAndFTP to access your OneDrive for Business. Enter Endpoint URL and click Authorize to open OneDrive for Business authorization page in your browser and sign in to your OneDrive for Business account.

On the next page, you will see the field with the authorization code. Copy it to the clipboard.

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

4i. Send Backups to Box


If you selected to send backups to "Box" - you will see this form.

On the Box Settings form you'll need to authorize SQLBackupAndFTP to access your Box. Click Authorize to open Box authorization page in your browser and sign in to your Box account and click at Allow.

On the next page, you will see the field with the authorization code. Copy it to the clipboard.

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

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


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

8. Advanced Schedule (optional)


You can set Differential and Transaction log backups in Advanced Schedule. Also on this form you can schedule the job to run at any custom schedule (more often than once daily).

9. Restore


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

To restore a database choose a backup from the list and select Restore from Backup... option, then click Restore.

Copyright © 2017 Pranas.NET

Heap | Mobile and Web Analytics Back to Top