How can we improve Windows Azure Data Management: SQL Database?

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

115 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    anonymousanonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    8 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Juan BetancourtJuan Betancourt commented  ·   ·  Flag as inappropriate

        Don't forget federation, it is important to be able to backup and restore even at the single atomic unit level.

      • Paul CombellickPaul Combellick commented  ·   ·  Flag as inappropriate

        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 GoldenRichard Golden commented  ·   ·  Flag as inappropriate

        I'm currently building an application that uses SqlAzure and this would really help out. Thanks!

      • Simeon PottsSimeon Potts commented  ·   ·  Flag as inappropriate

        +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.

      Feedback and Knowledge Base