Time-Out & Fail on Remote SQL Server Backup (12.2.3)


#1

Running 12.2.3 which was supposed to address this, however still getting timeout on backup of remote SQL database. I can’t seem to find a way to attach a log, so here it is (sorry). The DBA password is very very strong! Is there a timeout setting or ???

5/1/2019 5:27 PM Starting job "Gemini at TMD " - "Full". Computer "BOB". App v."12.2.3" 
5/1/2019 5:27 PM Connecting to Remote SQL Server: 2017 RTM Express Edition (64-bit). win06.tmd.cloud 
5/1/2019 5:27 PM The backup folder "C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup" has "305.730GB" free space. The temporary folder "C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup" has "305.730GB" free space 
5/1/2019 5:27 PM Backing up "win06.tmd.cloud" Remote SQL Server databases 
5/1/2019 5:27 PM Getting maximum file size... 
5/1/2019 5:27 PM The maximum file size: "" 
5/1/2019 5:27 PM Backing up "geminidc_rdenny" database to .sql file 
5/1/2019 5:27 PM Prefetching objects of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting geminidc_rdenny database 
5/1/2019 5:28 PM Scripting users and roles of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting schemas of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting user defined types of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting assemblies of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting user defined aggregates of geminidc_rdenny database 
5/1/2019 5:28 PM Scripting user defined functions and user defined procedures definitions of geminidc_rdenny database 
5/1/2019 5:29 PM Scripting tables of geminidc_rdenny database 
5/1/2019 5:32 PM Failed to backup "geminidc_rdenny" database with "Full" backup type: Script failed for Table 'dbo.gemini_issueattachments'.  > Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. > The wait operation timed out 
5/1/2019 5:32 PM Cleaning up backups of "Gemini at TMD " job 
5/1/2019 5:32 PM Job "Gemini at TMD " finished with "1" errors

#2

Hi Bob_Denny,

Thanks for the details. Please give us some time to check the issue.

Sorry for the inconvenience.


#3

Dear Bob_Denny,

We have added some changes to SQLBackupAndFTP Alpha version https://sqlbackupandftp.com/download/alpha could you please download, install it and specify the timeout you need at the “Advanced settings” at the “Connect to Server” window.

SQLBackupAndFTP

Sorry for the inconvenience.


#4

I got the alpha and the timeout just meant solved my problem!! Thank you. I have purchased the $39 license. This is nice software!! I love the functionality. Nothing is better for this.


#5

Hi Bob_Denny,

Good news! Thank you for your reply and for the warm words.

Please feel free to contact us on any issues or concerns.