Finance | Project Operations, Human Resources, ...

Trying to export after Database refresh and Export is failing

(0) Share

Report

Posted on by Ann2015

1,128

I did a Database refresh from prod to stage.
When I tried to export the database it is throwing a "preparation failed" error. I tried to "resume" twice but no luck.
The log file is empty and so I don't know what the issue is. Any idea what I can do next?

Thank you

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report
Copy link

Link copied!

Hi Ann2015.

As the export is done by Microsoft logic I suggest to create a LCS support request. Strange to me is the empty log file. So I assume the Problem / error in in the beginning on the procedure.

Best regards

Christoph

Was this reply helpful? Yes No
Suggested answer

Asif365 1,431 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The export process can time out on Azure SQL Database when large databases are involved. In some cases, the export process can be recovered by using the Resume action from LCS. The Lifecycle Services team is working to identify known error codes, so these can be added to the logs for the export database operation to help guide users toward a resolution.

docs.microsoft.com/.../export-database

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,732 on at

Like (0)

Report
Copy link

Link copied!

Hello Ann2015,

Try by resuming it first. If not solved, then log a case to Microsoft to look after this.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Deekshit Addepalli Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Have you also attempted the manual export/import process? This will bypass LCS, but will only work if your database is not on an elastic pool.

Was this reply helpful? Yes No