ERROR backup from rds server

Application issues
1

I am trying to backup my rds server to my local computer, and i have this error. Not sure what i should do.
i download the timeouts.xml, and still get same fault.
I have extended
CloudSQL>short to 3600, long: 43200
NetPipe> OpenTimeOut > 3600
NetPipe> SendTimeOut> 3600
NetPipe> CloseTimeout > 3600
Still same error.
>
> |06/02/2021 2:35:42 PM|[Info]|Starting job "Backup Job - 1 " - “Full”. Server “COMPUTER”. Account “SYSTEM@ABC”. App v.“12.5.13”.|
> |—|---|—|
> |06/02/2021 2:35:42 PM|[Info]|Connecting to: 2017 RTM Express Edition (64-bit). rds.amazonaws.com.|
> |06/02/2021 2:35:43 PM|[Info]|The backup folder “C:\windows\TEMP\SYSTEM\Pranas.NET\SBF\73491b80-2371-4add-b44f-dac1349dd268\backup” has “190 GB” free space. The temporary folder “C:\windows\TEMP\SYSTEM\Pranas.NET\SBF\73491b80-2371-4add-b44f-dac1349dd268” has “190 GB” free space.|
> |06/02/2021 2:35:43 PM|[Info]|Backing up “rds.amazonaws…” Amazon RDS SQL databases.|
> |06/02/2021 2:35:43 PM|[Warning]|For an export to be transactionally consistent, you must ensure either that no write activity is occurring during the export. Turn on “Make database ReadOnly” option at Backup options section for export to be transactionally consistent.|
> |06/02/2021 2:35:44 PM|[Info]|Backing up “database” with “Full” backup type.|
> |06/02/2021 2:45:48 PM|[Error]|Failed to backup “database” 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|
> |06/02/2021 2:45:49 PM|[Info]|Cleaning up backups of "Backup Job - 1 " job.|
> |06/02/2021 2:45:49 PM|[Error]|Job "Backup Job - 1 " finished with “1” errors.|

2

Hi Johnny,

To resolve the issue please try to increase value in the CloudSql section in the Timeouts.xml file. You can do it in the following way:

  1. Please save the following Timeouts.xml file into the following folder C:\ProgramData\Pranas.NET\SQLBackupAndFTP\Service
  2. Open the Timeouts.xml file and find the CloudSql section
  3. Increase the timeouts values and save the changes
  4. After adding each new setting please restart SqlBak (SQL Server Backup) Windows Service

Please find more details at How to increase timeout values | SQLBackupAndFTP's blog

If you have any other questions, please let us know.

Sorry for the inconvenience.