ImportExport operation failed Error SQL72014: Framework Mi'. (Code: ImportExportJobError)

Question

We're trying to import a .bacpac file from blob storage into an Azure SQL Server. But we're getting the error below even if we already deleted the database.

It's a clean server, and it's a Microsoft.SQLDatabase.newDatabaseImportExistingServer

{"code":"ImportExportJobError","message":"The ImportExport operation with Request Id 'af0baede-d5a4-46a7-82fe-8a8410ff201d' failed due to 'Could not import package.\nWarning SQL72012: The object [data_0] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.\nWarning SQL72012: The object [log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.\nError SQL72014: Framework Mi'."}

Thank you!

Answer 1

Hi Jay Manarang,

As you mentioned, it's a clean server.

Looking at the error it seems BACPAC copy is not transactionally consistent.

While exporting the database have you followed below steps and consideration.

For an export to be transactionally consistent, you must ensure either that no write activity is occurring during the export, or that you are exporting from a transactionally consistent copy of your database. 

Reference document - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql#considerations

Thank you!