Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How do I back up and restore a SQL Azure database?

For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account before my company comes onboard and says that there is a corporate account for me to work on? How do I move all my stuff from one account to another?

share|improve this question

migrated from stackoverflow.com Sep 20 '12 at 11:27

This question came from our site for professional and enthusiast programmers.

    
One option for backup would be Red Gate cloud services : red-gate.com/products/dba/sql-azure-backup –  Aaron Bertrand Sep 18 '12 at 23:51
    
You can export and import to blob storage, which is basically a backup and restore. msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx –  Craig Sep 19 '12 at 0:41
    
I have managed to use the sql management studio to move the tables from one database to the new one after I created the new database online with SQL Azure. I tried all sorts of sync steps and downloads but in the end I just did this easy step by hand. –  xarzu Sep 19 '12 at 20:22
    
You have a free utility called Enzo Backup that provides SQL Azure backup/restore capabilities. The newer version (currently in Beta) allows you to backup/restore Azure Tables as well. bluesyntax.net/backup.aspx –  Herve Roggero Sep 20 '12 at 18:00
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.