Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure SQL Export via https://portal.azure.com Never Completes

Have tried exporting our sql database several times, several different copies (regional replication), and we always get a zero byte file in our storage blob account. No statuses, no error messages.

Any hints?

Edit: None of the below answers solved my issue. The issue was there was an invalid view in the database, which was causing the export to silently fail.

like image 991
kevinc Avatar asked Aug 23 '16 01:08

kevinc


1 Answers

Perform the "Export Data-tier Application" task from SQL Server Management Studio instead. This will provide you with detailed progress about the export.

Step by step instructions:

  1. Open SQL Server Management Studio (2016 or above)
  2. Connect to the Azure SQL Server
  3. Right click on the required database, choose "Tasks" and "Export Data-tier Application"
  4. Follow the wizard
like image 150
Josh Gallagher Avatar answered Sep 20 '22 13:09

Josh Gallagher