is there a script available which take back up of database which is in SQL Azure???
Asked
Active
Viewed 328 times
1
-
There is a service that does this (currently free). See here: http://dacguy.wordpress.com/2011/09/10/sql-azure-importexport-service-ctp-now-available/ – dunnry Oct 14 '11 at 13:41
3 Answers
2
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 .
1
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.
David Steele
- 3,433
- 21
- 23
0
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
