Azure SQL - Backup always fails after 25min

Application issues
1

Hello,

For some time now, the Azure SQL database backup always fails on any database that takes more than 25 mins. It fails at the 25th minute with the following errors:

I also extended the timeout XML file with 24 long job timeout but no change.

Any idea what the problem could be?

2022-12-29 11:33:30.8015|DEBUG|50|Pranas.Net.SqlBak.Service.Scheduler.ActionScheduleJob|Execute. Return
2022-12-29 11:33:30.8135|DEBUG|50|Quartz.Core.JobRunShell|Trigger instruction : NoInstruction
2022-12-29 11:33:54.9669|DEBUG|6|Quartz.Core.QuartzSchedulerThread|Batch acquisition of 0 triggers
2022-12-29 11:33:56.8308|DEBUG|19|Pranas.NET.SqlBak.Job.Sql.Business.SqlServerHelper|BackupDatabaseCloud. DacServices message. Number: “73100”; MessageType: “Message”; Prefix: “SQL”; Message: “Extracting schema (Failed)”.
2022-12-29 11:33:56.8308|ERROR|77|Net.Pranas.SqlBak.Tools.Task.TaskTools|TryWhileTimeSpan|Microsoft.SqlServer.Dac.DacServicesException: Could not extract package from specified database. —> Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlReverseEngineerException: Database ‘tcprod-audit_SQLBackupAndFTP_Snapshot’ on server ‘tcprod-dbserver’ is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of ‘6B2480ED-2C1C-4CFA-B2E0-E1E5C0E869A4’. —> Microsoft.Data.SqlClient.SqlException: Database ‘tcprod-audit_SQLBackupAndFTP_Snapshot’ on server ‘tcprod-dbserver’ is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of ‘6B2480ED-2C1C-4CFA-B2E0-E1E5C0E869A4’.

2

Hi Ales_Sturala,

To resolve the issue, please try to increase the timeout value in the Timeouts.xml file in the CloudSql > Short section. For example, you can set it to 1200.

You can find the Timeouts.xml file at Dropbox - Timeouts.xml - Simplify your life

Here are more details on how to work with Timeouts.xml How to increase timeout values

Please let us know if you have any other questions.

Thank you and sorry for the inconvenience.

1 Like