Hi,

I recently upgraded my database server to the V12 (GA in my region). I have 3 servers running and configured for an automated backup at 12:00 AM every day.

This morning I discovered we had 20 additional SQL Servers running, each one with an hourly time stamp from the last which I can only imagine is a re-try of the original export. When trying to delete these databases the portal said "An error occurred whilst existing this request, please re-send". I did try to re-send several times for each database and they all failed. Approximately 20 minutes later all the databases started to just disappear on their own (After I had turned off the automated backup in the settings).

I checked over the upgrading documentation and couldn't find any details of problems with the Automated backups post upgrade so I am unsure if this is a bug in the system or a problem on the particular databases?

I have manually run the backups as indicated in the error email and that worked fine.

Thanks

Hello CAWeb,

My name is Eli Fisher and I am a Program Manager on the SQL DB team. We are aware of the issue you have stated above and there is work being done to fix the issues.

I would be glad to look into your specific issue for more details. If you would like, you could send your database name and server name to my email address and I could look further into what is happening. My email alias is elfish at Microsoft dot com.  

Additionally, if you are using automated export for backup purposed, we have built in backups for all Basic, Standard, Premium databases. You can use these backups to restore up to any point in time within your database's backup retention period. Additionally a daily backup is made geo-redundant so if there is a regional disaster you would be able to restore your database. If you would like to learn more about these capabilities look here:

Point in Time Restore Blog http://azure.microsoft.com/blog/2014/10/01/azure-sql-database-point-in-time-restore/

Geo-Restore Blog http://azure.microsoft.com/blog/2014/09/13/azure-sql-database-geo-restore/

How-To use the Restore capabilities:

Geo-Restore: http://azure.microsoft.com/en-us/documentation/articles/sql-database-geo-restore-tutorial-management-portal/

Point in Time Restore: http://azure.microsoft.com/en-us/documentation/articles/sql-database-point-in-time-restore-tutorial-management-portal/

Restore a deleted database: http://azure.microsoft.com/en-us/documentation/articles/sql-database-restore-deleted-database-tutorial-management-portal/

Hope this helps!

• Marked as answer by Eric__ZhangMicrosoft contingent staff, Moderator Wednesday, March 04, 2015 5:37 AM