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

image

Step2: Drop the database

image

Step3: Choose Restore

image

image

Step4: Restoring

image