SQL Azure Database Backup & Restore

  • Hi All,

    How can we take the backup of database in SQL Azure?

    --- i have taken the backup of database by using "AS COPY OF" it has created a database

    Now, how can i restore this backup?



  • Microsoft doesn't really support a direct mechanism of backup & restore through Azure. You can do an export/import through the Azure storage. I have a blog post about it here. It's not the same thing as a backup.

    You could look at Red Gate's Cloud Services utility. It does a lot of what you'd want in a real backup process plus more.

    Disclaimer, I work for Red Gate.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply