A lot of early adopters have asked about this “missing feature” in SQL Azure. Whilst workarounds exist (such as using BCP and SQL Server Integration Services), folks still wanted the backup and restore capabilities they lean on for SQL Server.
At TechEd in May David Robinson confirmed that we would be delivering a database restore capability for SQL Azure.
Watch from 38mins
Screenshots from the upcoming CTP:
Step1: Backup is enabled for the database
Step2: Drop the database
Step3: Choose Restore