Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error<\/p>
——————————<\/p>
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].[C].
Error SQL71501: Error validating element [jobs]: Schema: [jobs] has an unresolved reference to object [##MS_JobAccount##].
Error SQL71501: Error validating element [jobs_internal]: Schema: [jobs_internal] has an unresolved reference to object [##MS_JobAccount##].
\u00a0(Microsoft.SqlServer.Dac)<\/p>
——————————<\/p>
This is due to references from the Database to the Elastic Jobs DB<\/p>
The way around this is to Copy the database to another database in azure, remove the references on SQL to the Elastic Jobs DB then Export this Database<\/p>","protected":false},"excerpt":{"rendered":"
Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error——————————One or more unsupported elements were […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3914,1464,736,3912,2767,3913,3915],"class_list":["post-6014","post","type-post","status-publish","format-standard","hentry","category-research","tag-ms_jobaccount","tag-azure","tag-backup","tag-bacpac","tag-export","tag-has-an-unresolved-reference-to-object","tag-jobs_internal"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t