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

Enter your idea

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

Hot ideas
Top ideas
New ideas
Status
My feedback

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
4 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
6 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
0 comments · Admin →
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 : <hidden>
[23:05:21]: 0% Creating temporary copy of Azure database
[23:14:21]: Error: The operation has timed out
[23:14:21]: Details:
[23:14:21]: BlobUri: <hidden>.bacpac
[23:14:21]: DatabaseName: <hidden>
[23:14:21]: ErrorMessage:
[23:14:21]: LastModifiedTime: 2012/02/22 21:08:01
[23:14:21]: QueuedTime: 2012/02/22 21:08:00
[23:14:21]: RequestId: 98ab657f-adea-4d5b-be24-4fef25dcd307
[23:14:21]: RequestType: Export
[23:14:21]: ServerName: <hidden>.database.windows.net
[23:14:21]: Status: Running, Progress = 90%
[23:14:21]: 100% Dropping copy of Azure database
[23:14:27]: System.AggregateException: One or more errors occurred. ---> System.Net.WebException: The operation has timed out
[23:14:27]: at .? .?? (Uri , Int32 , Exception , String )
[23:14:27]: at .? . (HttpWebRequest )
[23:14:27]: at .? . (String )
[23:14:27]: at ?? . ? .? (?? , CancellationToken , String )
[23:14:27]: at ?? . ? .?? (?? , CancellationToken )
[23:14:27]: at ?? . ? . (CancellationToken , ?? , ?? , ? )
[23:14:27]: at RedGate.SQLAzureBackup.Engine.AzureBackupEngine. (CancellationToken , ?? , ?? , ? )
[23:14:27]: at ?? . ? . ? .? ?(Object )
[23:14:27]: at System.Threading.Tasks.Task.InnerInvoke()
[23:14:27]: at System.Threading.Tasks.Task.Execute()
[23:14:27]: --- End of inner exception stack trace ---
[23:14:27]: at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
[23:14:27]: at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
[23:14:27]: at System.Threading.Tasks.Task.Wait()
[23:14:27]: at ?? . ? . (String[] )
[23:14:27]: ---> (Inner Exception #0) System.Net.WebException: The operation has timed out
[23:14:27]: at .? .?? (Uri , Int32 , Exception , String )
[23:14:27]: at .? . (HttpWebRequest )
[23:14:27]: at .? . (String )
[23:14:27]: at ?? . ? .? (?? , CancellationToken , String )
[23:14:27]: at ?? . ? .?? (?? , CancellationToken )
[23:14:27]: at ?? . ? . (CancellationToken , ?? , ?? , ? )
[23:14:27]: at RedGate.SQLAzureBackup.Engine.AzureBackupEngine. (CancellationToken , ?? , ?? , ? )
[23:14:27]: at ?? . ? . ? .? ?(Object )
[23:14:27]: at System.Threading.Tasks.Task.InnerInvoke()
[23:14:27]: at System.Threading.Tasks.Task.Execute()<---
[23:14:32]: Process exited with code 1000

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
3 comments · Admin →

started · AdminRichard Mitchell (Project Manager, Red Gate Software Ltd) responded

I’ve got I believe to be a fix, hope to get it out next week. Looks like whatever was in North Europe and breaking has been pushed live globally.
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

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 has timed out
at ????.????.???(Uri , Int32 , Exception , Stri
at ????.????.????(HttpWebRequest )
at ????.????.????(String )
at ????.????.??(???? , CancellationToken , Stri
at ????.????.????(???? , CancellationToken )
at ????.????.????(CancellationToken , ???? , ¦?
at RedGate.SQLAzureBackup.Engine.AzureBackupEng
at ????.¶??.?.¤??.???(Object )
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfException
at System.Threading.Tasks.Task.Wait(Int32 milli
n)
at System.Threading.Tasks.Task.Wait()
at (Object )
at ????.¶??.???(String[] )
---> (Inner Exception #0) System.Net.WebException:
at ????.????.???(Uri , Int32 , Exception , Stri
at ????.????.????(HttpWebRequest )
at ????.????.????(String )
at ????.????.??(???? , CancellationToken , Stri
at ????.????.????(???? , CancellationToken )
at ????.????.????(CancellationToken , ???? , ¦?
at RedGate.SQLAzureBackup.Engine.AzureBackupEng
at ????.¶??.?.¤??.???(Object )
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()<---

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
1 comment · Admin →

started · AdminRichard Mitchell (Project Manager, Red Gate Software Ltd) responded

This the same timeout error others are having problems with. I’ve got a fix, just trying to coax it out of our build system to release.
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
1 comment · Admin →
Error: DNS lookup timed out for db3prod-dacsvc.azure.com

command line fails...

any idea?
3 votes
Vote

Sign in
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
0 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
2 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
2 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
2 comments · Admin →
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:
LastModifiedTime: 2/27/2012 5:59:31 PM
QueuedTime: 2/27/2012 5:59:30 PM
RequestId: 21afcd63-b3fa-4091-8294-44fe3354f20a
RequestType: Export
ServerName: <hidden>.database.windows.net
Status: Running, Progress = 0%
System.AggregateException: One or more errors occurred. ---> System.Net.WebExcep
tion: The operation has timed out
at ????.????.???(Uri , Int32 , Exception , String )
at ????.????.????(HttpWebRequest )
at ????.????.????(String )
at ????.????.??(???? , CancellationToken , String )
at ????.????.????(???? , CancellationToken )
at ????.????.????(CancellationToken , ???? , ??? , ???? )
at RedGate.SQLAzureBackup.Engine.AzureBackupEngine.????(CancellationToken , ?
??? , ??? , ???? )
at ????.???.?.???.???(Object )
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceled
Exceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationTo
ken cancellationToken)
at System.Threading.Tasks.Task.Wait()
at (Object )
at ????.???.???(String[] )
---> (Inner Exception #0) System.Net.WebException: The operation has timed out
at ????.????.???(Uri , Int32 , Exception , String )
at ????.????.????(HttpWebRequest )
at ????.????.????(String )
at ????.????.??(???? , CancellationToken , String )
at ????.????.????(???? , CancellationToken )
at ????.????.????(CancellationToken , ???? , ??? , ???? )
at RedGate.SQLAzureBackup.Engine.AzureBackupEngine.????(CancellationToken , ?
??? , ??? , ???? )
at ????.???.?.???.???(Object )
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()<---

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
3 comments · Admin →

started · AdminRichard Mitchell (Project Manager, Red Gate Software Ltd) responded

Another issue with timeout others have reported, I’ve got a local fix that I will release as soon as I can extract it from the build system.
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
0 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
0 comments · Admin →
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
prestine

Your email address
Check!

invalid email

(thinking…)

Reset

or sign in with

UserVoice password

Forgot password?

Create a password

Your name
I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)
1 comment · Admin →

Don't see your idea?

General

I suggest you ...

There are two ways to get more votes:

Synchronise to an existing local database

Make it possible to tik which objects that should be backed up.

Restore from bacpac doesn't set Max Size of original

Name the database object in error messages where possible

Make it so it automatically overwrites an existing Blob when backing up to storage

Error: Operation has timed out

Support for Geometry data type

Version 2.6 command line fails with SqlException

Make text in progress bars readable

Error: DNS lookup timed out for db3prod-dacsvc.azure.com

Cost Estimate of the Backup

Migrate SQL Server features to SQL Azure compatible syntax

Determine location of local database

Backup Azure with timeout error

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 !

Back up is thrice the size of original sql azure database

SQL azure backup using commandshell

Backup failing on IDENTITY_INSERT error

Feedback

General

Feedback and Knowledge Base

Searching…

Give feedback

Red Gate Software Ltd