Set Database Extension fails with GatewayTimeout after restoring DB from .bacpac

Michael Fanning 1 Reputation point
2020-07-14T06:28:50.987+00:00

I am attempting to import a database via a .bacpac file which I have stored in blob storage.

I have created an Azure SQL serve, and followed the import steps described in the video attached: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell

After completing, the DB is available in resources, however when I use the query editor I cannot see any of the DB tables.

Within my activity log, the "Set database extension" task has been repeating and failing every couple of minutes, with the error "The gateway did not receive a response from 'Microsoft.Sql' within the specified time period." Within the error JSON the properties are as follows:

"properties": {
"statusCode": "GatewayTimeout",
"serviceRequestId": null,
"statusMessage": "{\"error\":{\"code\":\"GatewayTimeout\",\"message\":\"The gateway did not receive a response from 'Microsoft.Sql' within the specified time period.\"}}",
"eventCategory": "Administrative"
},

Any help with this would be greatly appreciated

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,283 questions
Azure Database Migration service
Azure SQL Database
Azure Application Gateway
Azure Application Gateway
An Azure service that provides a platform-managed, scalable, and highly available application delivery controller as a service.
1,079 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.