How do you back up your SQL Azure database? [closed]

Question

What is the best way to perform a nightly, automatic backup of a SQL Azure database? I make random backups when I need to before changes using the "create database xxx as copy of yyy" technique but I need something automatic.

I've considered using the Import/Export feature in SQL Azure Labs with a script that runs nightly to export to my laptop

https://www.sqlazurelabs.com/ImportExport.aspx

That sure seems a bit clunky for a service that's supposed to be enterprise ready, though.

Are there better ways to perform SQL Azure backups?

Answer 1

I haven't used it myself, but might be worth a look at Red Gate's SQL Azure Backup. It's currently in beta (expires 1st Sept), and is free. TBH, I'm not sure there are currently a lot/any other options at the moment.

Also see the linked article from there to Grant Fritchey's post on the tool.

Answer 2

Try our SQLBackupAndFTP tool to backup Azure databases to a local folder or to a clouds (Dropbox, Box, Google Drive, Amazon S3 or SkyDrive). Some clouds are available only in a paid version, but you can try all features in Trial mode. Just select SQLBackupAndFTP with Azure to download it.