Allow sql backup for Sql Azure
Not knowing where your data is and moving to another cloud hosting provider could be a nightmare if you cant retrieve the stored data into one file
P Velachoutakos commented
You can try the import ,export feature ,sending a export backup to storage account.
Juan Betancourt commented
Don't forget federation, it is important to be able to backup and restore even at the single atomic unit level.
+ 1 with restore points. Plz.
Paul Combellick commented
I know that SQL Azure provides replication to a total of 3 datastores; however, this does not protect me from "drop table", etc. It is important to have full and differential backup support. It is necessary to backup federation members, separately. I would like to see the backup written to Azure blob storage, rather than using the SQL Azure database copy feature. I agree with Simeon's idea to backup to a file then move to the premisis.
Richard Golden commented
I'm currently building an application that uses SqlAzure and this would really help out. Thanks!
The ability to backup to a standard SQL backup file would be great!
Simeon Potts commented
+1. We would like to be able to back up SQL Azure databases to a SQL 2008 R2 .bak file and download it out of the cloud. So that we can keep snapshot backups in the event that we damage our data, and so that we can pull a customer's data out of the cloud immediately if they cancel their service.
Andy Hitchman commented
The ability to perform a standard backup, or log ship out of the cloud?