Cant create export of database

Question

I cant create an export of one of our databases.

ERROR:

The ImportExport operation with Request Id '6001476a-69a8-46df-a766-70dc38edf723' failed due to 'One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating element [TaskHosting]: Schema: [TaskHosting] has an unresolved reference to object [##MS_SyncAccount##]. Error SQL71501: Error validating element [dss]: Schema: [dss] has an unresolved reference to object [##MS_SyncAccount##].

I already tried making a copy and running this script:
https://techcommunity.microsoft.com/blog/azuredbsupport/exporting-a-database-that-iswas-used-as-sql-data-sync-metadata-database/369062

Answer 1

Hi Gino,

I kindly request you to please share the details requested in the private message for further investigation.

Answer 2

Follow https://techcommunity.microsoft.com/blog/azuredbsupport/exporting-a-database-that-iswas-used-as-sql-data-sync-metadata-database/369062

In order to successfully export the database, you need to:

1. Create a database copy. You can check how to create a copy of the database using the portal at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-copy-portal (there is also documentation for doing this using T-SQL or PowerShell)
2. Remove the Data Sync metadata objects from the copy. You can find a script to do it on GitHub
3. Make sure you are connected to the copy.
4. Export the database from the copy.
5. Delete the database copy.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin