Unable to backup sql azure to a bacpac in blob

Lalit 101 Reputation points
2020-06-04T19:00:13.12+00:00

Hi, I have been trying repeatedly to backup a sql azure database to a bacpac file on blob. Each time I do, it fails with an error One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating element [dbo].[ScanInCacheFromDatabase]: Function: [dbo].[ScanInCacheFromDatabase] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [qp].[query_plan].[exist], [sys].[dm_exec_query_plan].[qp], [sys].[dm_exec_query_plan].[query_plan], [sys].[dm_exec_query_stats].[qp] or [sys].[dm_exec_sql_text].[qp]. (Microsoft.SqlServer.Dac) Any suggestions on how to make this work? Tx

Azure SQL Database
{count} vote

Accepted answer
  1. Lalit 101 Reputation points
    2020-06-17T06:54:11.633+00:00

    It has worked, tx everyone. I upgraded to P1 and deleted the procedure [ScanInCacheFromDatabase]. The procedure wasn't made by me, maybe a Azure system proc.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Leon Laude 85,596 Reputation points
    2020-06-04T19:40:33.167+00:00

    Hi,

    Something here may help:
    https://techcommunity.microsoft.com/t5/azure-database-support-blog/exporting-a-database-that-is-was-used-as-sql-data-sync-metadata/ba-p/369062

    Also check the "considerations" section over here:

    Export to a BACPAC file - Azure SQL Database and Azure SQL Managed Instance
    https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export

    Best regards,
    Leon

    0 comments No comments