General

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Synchronise to an existing local database

    It would be great if SQL Azure backup could synchronise to an existing local database. For large databases downloading and inserting all data to a new database every time takes too much.

    15 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…)
      1 comment  ·  Admin →
    • Make it possible to tik which objects that should be backed up.

      This way you could choose only tables, tables with data, views, stored procs, functions etc.

      14 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…)
        1 comment  ·  Admin →
      • Restore from bacpac doesn't set Max Size of original

        If I backup to Blob storage a SQL Azure database that is set as a Web Edition DB with a Max Size of 5GB, then restore it to another database the new database does not have a Max Size of 5GB. In my case the DB actually only has a few hundred MB of data but we want to allow it to expand up to 5GB in size.
        The restore should set the Max Size and Edition to whatever the original had.

        11 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…)
        • Name the database object in error messages where possible

          I am receiving the error message "unable to convert date / time from string". As the table and or field name isn't included in the error message I am unable to take any remedial action.

          6 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…)
          • Make it so it automatically overwrites an existing Blob when backing up to storage

            Right now, it says "Blob already exists" when trying to overwrite an existing Blob.

            6 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…)
            • Error: Operation has timed out

              Hi there, I have encountered fairly consisten failures when using the tool to backup two specific databases. They are both 250 tables+ but not necessarily all that big in size. A successful backup creates a bacpac of roughly 50mb.

              Please help! Failures look like this:

              [23:05:09]: SQL Azure Backup v2.6.1.100
              [23:05:09]: ===============================================================================
              [23:05:09]: Copyright (c) Red Gate Software Ltd 2011
              [23:05:19]: Backing up...
              [23:05:19]: SOURCE
              [23:05:19]: Azure Server : <hidden>.database.windows.net
              [23:05:19]: Azure Database : <hidden>
              [23:05:19]: Create Copy : True
              [23:05:19]: DESTINATION
              [23:05:19]: Access Type : Primary Access Key
              [23:05:19]: Storage Name : <hidden>
              [23:05:19]: Container : backups
              [23:05:19]: File…

              5 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…)
              • Support for Geometry data type

                Right now tables containing Geometry type columns get ignored. Would love to have them be supported.

                3 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…)
                  1 comment  ·  Admin →
                • Version 2.6 command line fails with SqlException

                  I have been seeing the following trying to back-up my sql azure db to blob storage:

                  SQL Azure Backup v2.6.0.86
                  ==================================================
                  Copyright (c) Red Gate Software Ltd 2011

                  Backing up...

                  SOURCE

                  Azure Server : mydatabase.database.windows.net
                  Azure Database : mydatabase
                  Create Copy : True

                  DESTINATION

                  Access Type : Primary Access Key
                  Storage Name : myblob
                  Container : db-backups
                  File : MY_Backup_2012_02_25_11_06.bacpac

                  Error: The operation has timed out
                  Details:
                  BlobUri: https://myblob.blob.core.windows.net/db-
                  DatabaseName: CopyOfMyDatabase
                  ErrorMessage:
                  LastModifiedTime: 2/25/2012 11:18:21 PM
                  QueuedTime: 2/25/2012 11:18:19 PM
                  RequestId: d1de583f-8e44-48f2-9f4a-c5755d7dda8f
                  RequestType: Export
                  ServerName: mydatabase.database.windows.net
                  Status: Running, Progress = 0%
                  100% Dropping copy of Azure databaseSystem.Aggrega
                  tem.Net.WebException: The operation…

                  3 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…)
                    1 comment  ·  Admin →
                  • Make text in progress bars readable

                    When the progress markers are is over the text , the text becomes virtually unreadable.

                    3 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…)
                      1 comment  ·  Admin →
                    • 3 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…)
                      • Cost Estimate of the Backup

                        Before the backup starts an estimate of the cost would be useful (not essential but helpful if you want to avoid running up your monthly Azure bill). Also after the backup a more accurate estimate would be great.

                        2 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…)
                        • Migrate SQL Server features to SQL Azure compatible syntax

                          I now get a message saying for example "NOT FOR REPLICATION" is not supported and the SQL Server --> SQL Azure restore stops leaving me with nothing.

                          Or at least check compatibility before the migration.

                          1 vote
                          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…)
                          • Determine location of local database

                            I would like to determine the final location of the local database on my hard drive. instead of picking the default location that the Azure db has and creating it there.
                            as a side note, it would be nice if I could have multiple copies created of the same single Azure database, with different logical and physical names.

                            1 vote
                            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…)
                            • Backup Azure with timeout error

                              I'm using RedGate command line (RedGate.SQLAzureBackupCommandLine.exe V2.6 ) to backup Azure in the cloud. But some of them often failed due to timeout error. Could you please help me to fingure it out? I have no idea for this error. Thank you very much!!

                              SQL Azure Backup v2.6.0.86
                              ===============================================================================
                              Copyright (c) Red Gate Software Ltd 2011
                              Backing up...
                              SOURCE
                              Azure Server : <hidden>.database.windows.net
                              Azure Database : <hidden>
                              Create Copy : False
                              DESTINATION
                              Access Type : Primary Access Key
                              Storage Name : <hidden>
                              Container : dailybackup
                              File : <hidden>
                              Error: The operation has timed out
                              Details:
                              BlobUri: <hidden>.bacpac
                              DatabaseName: <hidden>
                              ErrorMessage: …

                              1 vote
                              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…)
                              • this is the best tool ! too sad it has been discontinued ! Other tools didn't work for me due to collation problems, here it works !

                                this is the best tool ! too sad it has been discontinued ! Other tools didn't work for me due to collation problems, here it works !

                                1 vote
                                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…)
                                • Back up is thrice the size of original sql azure database

                                  When I take a back up of azure database to local SQL server, the size is thrice that of original database. What could be the reason?

                                  I used exec sphelpdb to know the DB size.

                                  1 vote
                                  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…)
                                    1 comment  ·  Admin →
                                  • SQL azure backup using commandshell

                                    I have been trying to backup the Azure database to my local sql server 2008 using commandshell but it takes nearly 45 minutes to do this and it does not even copy the data. only the table structure is seen after this process. can you please help me with this. earlier it used to take few minutes to do the same with successfully copying data into the tables.

                                    1 vote
                                    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…)
                                    • Backup failing on IDENTITY_INSERT error

                                      Using v2.0.0.38 the backup failed copying data with the following error:
                                      Explicit value must be specified for identity column in table 'x' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

                                      1 vote
                                      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…)
                                        1 comment  ·  Admin →
                                      • Don't see your idea?

                                      General

                                      Feedback and Knowledge Base