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?

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.