Hi we are using the Standard Version and all works fine, except for Backups from one Azure SQL Database. We always get the following error:
8/13/2020 3:59 AM Failed to backup “xxx” database with “Full” backup type: Could not extract package from specified database. > Unable to reconnect to database: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. > Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. > The wait operation timed out
8/13/2020 3:59 AM Cleaning up backups of “xxx” job.
8/13/2020 3:59 AM Job “xxx” finished with “1” errors.
- We have tried editing the Registry Keys of the VM where the Tool is installed.
- We have tried on different VMs at different times
- We have acivated AAdvanced Log where basically the same error is reported:
2020-08-13 05:59:02.6492|DEBUG|76|Net.Pranas.SqlBak.Job.Core.BackupJob.BackupJobHandler|BackupDatabases. Backup exception|Microsoft.SqlServer.Dac.DacServicesException: Could not extract package from specified database. —> Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlReverseEngineerException: Unable to reconnect to database: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. —> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. —> System.ComponentModel.Win32Exception: The wait operation timed out
— End of inner exception stack trace —
We know that the database is more complex then the others, but if i manually start a sqlpackage.exe command with timeout of 6000 than it works fine - bacpac export will be created.
Is there a way to set the timeout when exporting from Azure SQL DAtabase to be 6000s?
Best Regards