2. Connect to an SQL Server
Click the "Connect to SQL Server" button. The Connect form will open.
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
Select databases you want to backup by clicking
checkboxes next to them in the list. Or you can check
"Backup all Non-System Databases" (below the "Connect to SQL Server" button)
- 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.
4. Select where to store the backups (backup destinations)
Click "Add backup destinations"
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 Box (optional)
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, sign in your to Box 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.
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 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.
4g. Send Backups to SkyDrive (optional)
If you selected to send backups to "SkyDrive" - you will see this form.
On the "SkyDrive Settings" form you'll need to authorize SQLBackupAndFTP to access your SkyDrive. Click
"Authorize..." to open SkyDrive authorization page
in your browser, sign in your to SkyDrive 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.
6. Set up notification e-mails
Check "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). In the Free version "Automatic" service
is complimentary for 7 days and then you need to change it to send emails through GMail
or your own SMTP server.
7. 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.
8. Schedule the backup job
Check "Schedule this job". Choose a time to do full backup, usually
during the night.
9. Save the backup job
Press the Save button on the toolbar and name the job appropriately.
It is better to store the job on the same computer, not on the network.
10. 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).