CODEWITHSUNDEEP
azureazure-sql-databasebacpac
Uri
Uri

Reputation: 71

SQL Azure export stuck at pending

I logged in to the Azure Portal and tried to export an SQL Azure database. It failed numerous times before I identified an issue with the password I was using. Then I used the correct password and got a message that there's already a request for export that is at a pending status.

Since it isn't running (1:30 hours already when usually it should take around 15 minutes), I would like to cancel this operation and run an export again - that will hopefully finish successfully.

How can I cancel a pending export?

Upvotes: 7

Views: 6661

Answers (4)

ES Su
ES Su

Reputation: 78

Have you "delete locks" on storage account? Had the same issue, contacted MS and been told to remove locks on storage account. That did solve the problem.

Upvotes: 0

teqqra
teqqra

Reputation: 31

Stop-AzSqlDatabaseActivity with resourcegroup, database, server, and operation id.

you can get operation id from the portal -> sql server->import export operations.

or with the cmdlet get-azsqldatabaseactivity.

Upvotes: 3

Frank
Frank

Reputation: 11

I also wanted to cancel the export of my Azure SQL Database. I managed to do this by upscaling my database. This way it forced the failure of the export.

Upvotes: 1

Pradebban Raja
Pradebban Raja

Reputation: 463

As i see there is no option from the management portal to stop a pending Database Export operation.

If you want to stop it forcibly, you can probably delete the storage account/ Container where it is getting exported and set Allow Azure Services to No under Manage Allowed IP Addresses page.

If there is further issues, you need to contact Azure support to Stop the Export operation.

Upvotes: 1

Related Questions