locked
Exporting DB hangs or fails RRS feed

  • Question

  • Hello,

    May someone help me? I started DB export to Blob Storage one day ago, and it still reports "90% done".

    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?

    Sergei.


    • Edited by Sergei Kamnev Thursday, November 15, 2018 9:09 AM Clarification
    Thursday, November 15, 2018 9:09 AM

All replies

  • 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

    Are you trying to export a database of 200 GB or greater? If that is the case export to local storage.


    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/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

    2.Connect to the Azure SQL Server

    3.Right click on the required database, choose "Tasks" and "Export Data-tier Application"


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com


    Thursday, November 15, 2018 11:53 AM
  • Thank you, Alberto. The database is not 200G, but around that.

    I will try your suggestions.

    Sergei.

    Thursday, November 15, 2018 12:44 PM
  • Hello,

    Please keep us posted.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, November 15, 2018 2:13 PM
  • Tried one more time, and it was successful.

    I will bear in mind that the process can hang without any report/notification.

    Thank you for the help,

    Sergei.

    Saturday, November 17, 2018 7:46 PM
  • Returning to this problem.

    Trying to export the DB again, and it is in process for 3 days with 88% progress last two days.

    The problem is that I cannot start new export, it tells:

    Failed to export the database: .... ErrorCode: 409 ErrorMessage: There is an import or export operation in progress on the database '...'.

    How could I stop hanging process? I cannot find it anywhere, so I cannot make export.

    Sergei.


    Wednesday, December 5, 2018 9:15 AM