In this tutorial learn about a dead simple way to back up your SQL databases to the cloud. I’ll show you how to use SQLBackupandFTP to back up a database to OneDrive (SkyDrive). This tool is really great as provides a means to backup SQLExpress databases, which as you know, don’t have a built-in backup method.
Beyond that, the tool really takes the mystery out of setting up backup jobs and allow you to backup to other destinations such as an FTP server, DropBox, or Google Drive.
This tutorial is broken up into four sections:
- Installing SQLBackupAndFTP
- Setting up a OneDrive (SkyDrive) Account
- Configuring SkyDrive
- Setting up a Nightly Full Backup Job
Once you have completed this tutorial you’ll have made a backup of a database of your choice and saved it to the SkyDrive cloud.
So let’s get started.
This video runs through downloading and installing SQLBackupAndFTP.
After watching the video go to the download page to get a free copy (aff link) and then install the software on your local server.
Note: In this demo we install SQLBackupAndFTP on local server; however, you can install on a separate server and remotely backup your databases.
Setting up a OneDrive (SkyDrive) Account
Before you can back up to OneDrive you need to set up an account if you don’t already have one. This process is pretty straightforward. If you already have an account, you can skip to the next section; otherwise, just follow along with the video to get one set up.
Even if you don’t decide to use SkyDrive to store your backups, you’ll find the service useful. I use it to synchronize document between various computers. If you’re interested in know more about this, just tweet me @sqlkris.
Now that you have a sky drive account let’s get SQLBackupAndFTP setup to back up your database.
Configure SQLBackupAndFTP for OneDrive (SkyDrive)
Setting up SQLBackupAndFTP to target SkyDrive for backups is pretty straight forwards. The key is to ensure that the application is authorized to access your SkyDrive account. The following video walks you through the process.
Once you have the account authorized it is pretty easy to use the tool to save backups to SkyDrive. The Adventure Works database, all 195 MB, was backed up, compressed to 35 MB and uploaded to SkyDrive in a minute and a half using my home-based broadband connection.
Setting up a Nightly Full Backup Job
You can use SQLBackupAndFTP in “set it and forget it mode.” It is pretty easy to schedule backup and let them run autonomously. You can be alerted via email if there are issues.
This clip show how to setup a nightly job that targets SkyDrive
Keep in mind that the job schedule is being controlled by a local windows service on the computer and not SQL Agent.
Also, if the job fails you will receive email notification.
There are three steps to setup SQLBackupAndFTP to back up your databases to SkyDrive.
- Download and Install SQLBackupAndFTP
- Configure SQLBackupAndFTP to access SkyDrive
Setup Nightly Jobs to Back up your database