MSSQL Export Data-Tier Application Error SQL71501, SQL71562

Question

Dear Expert,

Good day, I using latest SSMS and export Data-Tier Application facing error Error SQL71501, SQL71562.

I attach with my log.

Error log.txt

can I know how I can solve this 2 error ?

thanks a lot.

Answer 1

Kelvin Shee Thanks for your feedback, as I mentioned above we need more details to understand the steps you ar following, however when the database is/was used as an Elastic Jobs database we need to rely on the following method because there are some security-related objects that are not supported in export at the moment.

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

• 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)
• Remove the Elastic Job-related objects from the copy. Please make sure you are connected to the copy.
• Export the database from the copy.

If you are still facing the issue please add more details or an email with the below details,

Thread URL: Link to this thread.

Your Azure Subscription ID:

Email Subject : Attn Geetha

Regards

Geetha

Answer 2

Hi @Kelvin Shee

Regarding Error SQL71562, it is an error usually seen in stored procedures after migrating to Azure. The error is seen when something has a four-part table reference. For example: [SEMR].[CDD].[Tooth].[ctcm]. These are not supported and result in a SQL 71562 error.

You may be able to identify the issue by querying your [sys] tables for procedures and views that specifically reference a server or database.

For stored procedures:

SELECT OBJECT_NAME(object_id),
       OBJECT_DEFINITION(object_id)
  FROM sys.procedures
 WHERE OBJECT_DEFINITION(object_id) LIKE '%[DB_NAME]%'--replace 

Regarding Error SQL71501, please refer to this blog: Error sql71501 on exporting azure sql database.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.