Hi,

I was trying to export the data-tier application (BACPAC) to Azure blob storage by using SSMS  2014 but the operation failed. The error message is  

TITLE: Microsoft SQL Server Management Studio ------------------------------
Operation could not be completed within the specified time. (Microsoft.SqlServer.StorageClient)
------------------------------ ADDITIONAL INFORMATION:
The remote server returned an error: (500) Internal Server Error. (System)
------------------------------ BUTTONS:
OK

------------------------------

Earlier I uploaded BACPAC to Azure storage several times but didnot get this error. Any idea?

Edit: I installed SSMS 2014 CU6 and DACFramework.msi both x86 and x64. Still I can't export BACPAC from local machine to Azure blob storage..

• Edited by Tnt2015 Tuesday, August 25, 2015 5:27 AM

Hi Tnt2015,

If the export is long running, this could cause storage timeout issues.

One option to get around this would be to first export to local disk. Then upload the file to Azure Storage using Visual Studio or another tool for managing Azure Storage Accounts.

If you don't mind, can you share some more information about the database? Were there any significant changes to the database between when export worked and stopped working?

Thanks,

-Eli

• Edited by Eli FisherMicrosoft employee Tuesday, August 25, 2015 10:24 PM