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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Your Answer

 
discard

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