Auto-backup SQL Azure

Question

I've tried to googling around looking for backup and restore solution for SQL Azure. So far I've found SQL Azure Migration Wizard and Red Gate's SQL Azure Backup.

However both of them do not have "automatic" / "scheduled" functionality.

Wondering is there any such product in the market.

I aware probably we can use worker role to perform BCP, is there any sample code / solution for that?

Answer 1

Allow me to propose a solution. it uses 1) powershell 2) windows task scheduler

1) Step 1: i found a cmdlet to backup SQL Azure database here : https://www.cerebrata.com/Products/AzureManagementCmdlets/Default.aspx

Download it - run it. It uses bcp and backs up data locally. Also it allows us to back it up on Azure blobs (if need be)

2) Step 2: Now, you can schedule power shell scripts - so you need to schedule them using windows task scheduler.

 

Even i am searching for such a product that let's you schedule SQL Azure backup's!

HTH,

 

---

Paras Doshi, I blog about SQLAzure @ http://www.parasdoshi.com

Answer 2

Keep in mind too that Microsoft has announced that backup & restore (well, more like "restore") will be coming to SQL Azure soon.  See the "Microsoft SQL Azure Advanced Administration: Backup,Restore and Database Management Strategies for Cloud Databases" video from TechEd - http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI313.

Answer 3

Keep in mind too that Microsoft has announced that backup & restore (well, more like "restore") will be coming to SQL Azure soon.  See the "Microsoft SQL Azure Advanced Administration: Backup,Restore and Database Management Strategies for Cloud Databases" video from TechEd - http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI313.

wow! Thanks!

---

Paras Doshi, I blog about SQLAzure @ http://www.parasdoshi.com

Answer 4

-- I aware probably we can use worker role to perform BCP, is there any sample code / solution for that?

yeah i found this - https://github.com/drewf/SQL-Azure-Backup-Role

check it out!

 

---

Paras Doshi, I blog about SQLAzure @ http://www.parasdoshi.com

Answer 5

Hi Daniell,

You can use DACPACCLI tool to create a backup from SQLAzure to your local computer as bacpac file and you can also restore it back to Another SQL Azure server or On-Premise SQL Server.

For detailed step by step instructions, read this below article

http://sqlxpertise.com/2011/05/11/dacimportexportcli-import-export-data-from-sql-azure-to-sql-server-vice-versa/

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, let us know by clicking "Vote as Helpful".