We were using the SQL Azure Export script as a scheduled task (Mon-Fri; 7am-7pm) for creating rolling backups for the last week. But now the backups started disappearing, so we checked the status on the management portal and got the error location Mon-11
already exists, but the worst part is that the existing backup is also deleted.
So now as a temp workaround we just send the backup command twice, first one fails and deletes the existing backup, and then the second one succeeds.
Can we log this issue somewhere, because I don't think this is expected behavior, either overwrite or fail and DON'T delete the existing backup.
This does seem concerning. Expected behavior is that the export request should fail if the filename already exists. Could you provide some more details on how you are submitting your request? Are you using a shared access key or the full
storage account key for your storage account?
Do you have any specific RequestIDs we could take a look at?
I'm not sure what you are attempting to achieve exactly. Do you want the file to overwrite? To avoid the issue, you could ensure that you submit export requests with a storage location that does not already house a file.
The issue where your file is deleted is not expected and will be fixed in the next service release. Thank you for bringing this to our attention.