Timeout restoring bacpac file

Question

Timeout restoring bacpac file

GCoelho 25

Hi,

I'm trying to restore a SQL Server Azure database backup, but I always get an error message at the end of the process indicating that there was a timeout: Error SQL 72014 , execution timeout expired. This way I can't restore the BACPAC file. The error always occurs when trying to restore triggers or stored procedures.

Any suggestions on how I should proceed ? lkSem título

Thank you

SSingh-MSFT 16,371 Reputation points Moderator

2023-01-13T09:17:29.4766667+00:00

Hi @GCoelho ,

Just checking in to see if the below answer by @Alberto Morillo helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-01-13T09:17:29.4766667+00:00

Hi @GCoelho ,

Just checking in to see if the below answer by @Alberto Morillo helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

If you are trying to restore the bacpac on Azure please try uploading the bacpac to storage account and then import it using Azure portal, and do not use SSMS for that operation.

If you are trying to restore an Azure SQL bacpac on a SQL Server on-premise or installed on a virtual machine, try upgrading the SQL Server instance to SQL 2022 and upgrade SSMS. to v19 then import again. You can also try using SqlPackage utility instead of SSMS.

GCoelho 25 Reputation points

2023-01-12T17:00:52.8266667+00:00

Thank you very much.

I'll try this.

Share via

Timeout restoring bacpac file

0 additional answers

Your answer