Tell me more ×
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.
up vote 2 down vote favorite

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
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

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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