导出数据库挂起或失败 [英] Exporting DB hangs or fails
问题描述
你好
有人可以帮助我吗?一天前，我开始将数据库导出到Blob存储，但它仍然报告已完成90％".
May someone help me? I started DB export to Blob Storage one day ago, and it still reports "90% done".
但是，在Azure存储上创建了一个大小为1kb的文件，而文件大小应该为几十GB.看来导出失败并显示错误.
However, there was a file created on Azure Storage with size 1kb while it should be several dozens Gbyte. It looks that export failed with an error.
我该如何进一步研究这个问题?如何导出数据库?
How could I further dig into the issue? How to export the DB?
谢尔盖.
推荐答案
你好，
当导出操作超过20小时时，很有可能已取消导出.在这种情况下，请在开始导出之前扩展数据库层.确保在数据库上没有读/写活动.确保所有大桌子 具有聚簇索引
Hello,
When the export operation exceeds 20 hours there is a good chance the export has been cancelled. In this case, scale up the tier of the database before beginning the export. Make sure there is no read/write activity on the database. Make sure all large tables have clustered indexes
You may have better experience exporting to premium storage.
Sometimes many users exporting databases on the same region may cause some export operations to take more time.
https://support.microsoft.com/zh-CN/help/2965554/azure-sql-database-import-export服务需要长时间导入o
https://support.microsoft.com/en-us/help/2965554/azure-sql-database-import-export-service-takes-a-long-time-to-import-o
A workaround that may work in your case, use SQL Server Management Studio (SSMS) to export the database instead of the portal. If you were using SSMS then switch to the portal to perform the export.
1.Open SQL Server Management Studio
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于导出数据库挂起或失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
