2. Connect to SQL Server
Click the "Connect SQL Server" button.
Server Name: Enter the name of SQL server you are connecting to (like
.\sqlexpress or 127.0.0.1,1433)
Click "Test Connection" to verify the connection. If the connection
fails, then first use SQL Server Management Studio (SSMS) to connect to your database,
then use exactly the same settings in SQLBackupAndFTP.
3. Select databases to backup
Select databases you want to backup by checking 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. Store backups in a Local/Network folder (optional if
you send to FTP)
Check "Store backups in a Local/Network folder". You need to store backup
on a different physical drive from where your databases reside or (better) on another
computer. Choose the target folder (like \\backupserver\sqlbackups\ or
D:\backups).
Note that the account that starts the job must have sufficient rights to write to
the target folder.
5. Send Backups to FTP (optional if you store backups on the
network)
If you would like the backups to be copied to your FTP server, check "Send backups
to FTP Server".
On "FTP Server" form you have to 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, then use just the same settings here.
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 "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 send through "Automatic"
option (web service on SQLBackupAndFTP.com). In Free version "Automatic" service
is complimentary for 7 days, 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 that appropriate people have received email
messages. Verify the target folders from "Local/Network Folder" or FTP server (if
specified) contains 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).