SQL SERVER – Simple Trick to Backup Azure Database with SkyDrive

August 20, 2013

Here is a simple trick to backup Azure database with SkyDrive for free. To ensure your SQL Server or Azure databases remain safe, you should backup your databases periodically. And it is important to store the backups in a reliable location. Microsoft SkyDrive currently offers 7GB free, Box offers 5GB free – both are reliable and it is simple to send your backups there. SQLBackupAndFTP in it’s latest version 9 added the option to backup to SkyDrive and Box ( in addition to local/network folder, NAS drive, FTP, Dropbox, Google Drive and Amazon S3). Just select the databases that you’d like to backup and select to store the backups in SkyDrive or Box. Below I will show you how to do it in details

Job finished message for SQL Server backup.

Select databases to backup

First connect to your SQL Server or Azure Sql Database. Then select the databases you’d like to backup.

SQLExpress connection window.

Connect to SkyDrive or Box cloud

If you have a free version of SQLBackupAndFTP Box destination is included, but SkyDrive destination will be disabled as it is available in the Standard version or above. Click “Try now” to get 30 days trial on all options

SQL BackupAndFTP Software Window.

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 an authorization code. Copy it to the clipboard. Box operation is just the same.

SkyDrive Settings.

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

Authorization Code copy and paste dialog box.

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

SkyDrive Settings Window.

That’s all what has to be done to backup to SkyDrive or Box cloud. You can now click on “Run Now” button to test this job.

SQL Server Backup To Azure.

Conclusion

Whatever is your preference for storing SQL backups, it is easy with SQLBackupAndFTP. Note that at the time of this writing they are running a very rare promotion on volume licenses:

5–9 licenses: 20% off
10–19 licenses: 35% off
More than 20 licenses: 50% off

Please let me know your favorite options for storing the backups

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.

SQL Azure, SQL Backup and Restore

Integer Division in T-SQL: Why Your Percentages Come Out Zero

Table-Valued Parameters: Sending Thousands of Rows in One Call

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

March 19, 2011

SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010

January 9, 2014

A tall woodpile against a cottage wall with space left for more, an axe in the chopping block, frost on the grass.

Planning for Data Growth

March 30, 2009

Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 120 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.