Its always a better idea to Keep Offsite backup of databases, “SQL Backup and FTP” allows you to do that freely
SQL Backup and FTP is available for download for free at http://sqlbackupandftp.com
It supports direct backup to
1. FTP
2. Local or Network Folder
3. Drop Box
4. Box
5. Amazon S3
6. SkyDrive
7. Google Drive
Professional Version also supports SFTP and FTPS and AES Encryption of Backup files
Please follow the below steps for installation
The installation has completed successfully, Let us launch SQL Backup and FTP and create a Backup
Select the databases you want to Backup
Click on “Add backup destination” to specify the backup destination
For our demo, Let us select Drop box option
Click on “Authorize…” and Login to your Drop Box account
Click “Allow” to approve the Drop Box access
Once Drop Box access is authorized, Please click on “Finish” to proceed. You can configure automatic cleanup of backups as well.
Specify the Folder to which Backup has to be done
Click “Test” to make sure it works
Once Test is completed, Click “Ok” to proceed
Let us now connect to SQL Server and do a backup, By default, if you have a SQL Server default instance running, it will automatically connect and display the databases, Please select the database which you want to backup
If you want to enable Email notifications, Please select and specify the email address
Click on “Email Settings” icon to Test and configure, You can you use your own SMTP Server, if you prefer
Click “Send Test e-mail” to make sure the notifications are working and click “Ok” to proceed
Scheduling the Backups
If you want the backup to run automatically at a specific time, Please enable the “Schedule this job” option
Please click on “Schedule Settings” to customize the schedule based on your requirement, once finished, Please click on “Save & Close” to proceed
Please click “Run Now” to test the job manually
Once test is completed, Now click on “Save” button on the tool bar to save the job.
Hope this helps !!!
SQLXpertise 