Can't Export Database since this database was made a Job Database for Elastic Jobs Agent.

Question

getting this error every time i try to export the DB:
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element [jobs_internal].[visible_targets_formatted]: View: [jobs_internal].[visible_targets_formatted] 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: [jobs_internal].[database_credentials].[C], [jobs_internal].[database_credentials].[name] or [jobs_internal].[targets].

I have now uninstalled the elastic jobs agent but still getting this error, seems to have left loads of tables lying around in the db

I am on PAYG with no support plan, how do i go about fixing this mess that Azure has created?

Answer 1

Hi @Alex Stephens

Welcome to Microsoft Q&A and thanks for your query.

This export error seems to be related to a known issue wherein automated export doesn’t handle databases where elastic jobs were configured. You can create a database copy using
https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

Then, remove the elastic job related objects "jobs_internal.*" from the copied database, Export the database and then you can delete the copied database.
SQL DB Product team already aware about this limitation and working on improvement.

Please keep us updated on how it goes.

Thank you!

Answer 2

Still have the same issue, still unable to backup any SQL db.

Anyone able to help?