Is there a script available to take backup of SQL azure database with data?

is there a script available which take back up of database which is in SQL Azure???开发者_Python百科

---

Well, backup like you know from MS SQL 2008 is not supported on Azure SQL http://msdn.microsoft.com/en-us/library/windowsazure/ff394115.aspx

Redgate has a free backup tool http://www.red-gate.com/products/dba/sql-azure-backup/

For information on how to do backup and restore using BCP.exe and http://sqlazuremw.codeplex.com/ then see http://social.msdn.microsoft.com/Forums/kk-KZ/ssdsgetstarted/thread/b2a3c161-96b1-4201-ac46-a747e1806be1 .

---

There is a great new product from www.bluesyntax.net which has a couple of options. It only costs 50 USD. There are options to backup to a local file or back up to blob storage.

They will give you a 30 day Evaluation Key if you ask.

In my opinion it is well worth a look. I am certainly going to be purchasing a licence.

---

There is now an export feature you can use from the Azure Management Portal to produce a BACPAC file which can then be imported as a local database. I found an excellent blog post (from the same blog @dunnry mentions in his comment on your question) that details the steps required and I have and summarised them in another answer.

If you do not mind the backup being on Azure too then look at the tSQL command

CREATE DATABASE MyDBBackup23_6_12 AS COPY OF MyDB