Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
FTP timeout errors - read me first Options · View
Previous Topic · Next Topic
ruslan
#1 Posted : Thursday, August 26, 2010 11:20:13 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Prior to SQLBackupAndFTP v. 5 we have experienced a lot of FTP timeout errors when uploading large files. The problem was solved in v.5 - we have switched to a different FTP engine.
Back to top
 Report Abusive | Report SPAM
info56
#2 Posted : Tuesday, January 31, 2012 5:48:32 AM Quote
Rank: Newbie

Groups: Registered

Joined: 1/30/2012
Posts: 3
My problem in FTP:

on a server is ok

on another server is Bad.

log server Bad:

SqlBackupAndFtp 6.4.5.22086 Professional

SUMMARY:
Database Autoplus: Backup - Success, FTP - Failure

DETAILED LOG:
31/01/2012 12:35:09 Creating backup of Autoplus to C:\temp
31/01/2012 12:35:11 Backup of Autoplus completed (bak size: 19105 KB)
31/01/2012 12:35:11 Compressing (internal zip) C:\temp\Autoplus201201311235.bak to E:\Backup_sera_AutoPlus\Autoplus201201311235.zip
31/01/2012 12:35:18 Compression completed (archive size: 2.861 KB)
31/01/2012 12:35:18 Removing the backup: C:\temp\Autoplus201201311235.bak
31/01/2012 12:35:18 Uploading E:\Backup_sera_AutoPlus\Autoplus201201311235.zip to ftp://87.12.65.170:21/
31/01/2012 12:35:39 WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21
31/01/2012 12:35:40 Trying to upload again...
31/01/2012 12:36:01 WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21
31/01/2012 12:36:02 Trying to upload again...
31/01/2012 12:36:23 ERROR: Upload failed: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21

Tanks.
Back to top
 Report Abusive | Report SPAM
AlexP
#3 Posted : Wednesday, February 01, 2012 2:42:27 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 175
I'm not sure that this error is related to this software. Please contact your FTP or network administrator.
Back to top
 Report Abusive | Report SPAM
Guest
#4 Posted : Wednesday, February 01, 2012 2:51:42 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
Hello,

I'm having the same problems while FTP-ing to a remove server.

Sometimes the does the backup&ftp all the 5 databases correcty,
And some other times the problems appears in two ways:

1. ERROR: Remote file size verification failed:
2. WARNING: A connection attempt failed because the connected party did not properly respond after a period of time

The failure is not in all the 5 databases, just to a random numbers of db:


Version: SqlBackupAndFtp 6.4.5.22086 Professional

The logs:

2/1/2012 4:19:25 AM Upload of D:\Backup\dbf201202010400.zip completed
2/1/2012 4:19:26 AM ERROR: Remote file size verification failed: Remote file size (163328000) is not equal to local one's (262057359)


1/22/2012 4:19:06 AM WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Back to top
  |
Guest
#5 Posted : Tuesday, April 10, 2012 11:10:11 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
I've the very same problem. My backup is very large after 7zip compression. It's cca ~30GB.
When the ftp upload finished, I got the same error:
"31/01/2012 12:35:39 WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21
31/01/2012 12:35:40 Trying to upload again..."

But earlier, with the SqlBackupAndFtp 5.5 version works fine with the same environment for more than a 1,5 half years now. But after I've upgraded to v6.4, I got these errors.

I've already tried my environment with smaller backups and this is working fine.

I think the problem is around the FTP's timeout settings. When uploading a large file the ftp session is going to timed out, but when trying to restoring the connection to verify the uploaded file, won't get response from the server and restarting the upload.

Please help.
Thanks in advance,
Andor Pribek

info56 wrote:
My problem in FTP:

on a server is ok

on another server is Bad.

log server Bad:

SqlBackupAndFtp 6.4.5.22086 Professional

SUMMARY:
Database Autoplus: Backup - Success, FTP - Failure

DETAILED LOG:
31/01/2012 12:35:09 Creating backup of Autoplus to C:\temp
31/01/2012 12:35:11 Backup of Autoplus completed (bak size: 19105 KB)
31/01/2012 12:35:11 Compressing (internal zip) C:\temp\Autoplus201201311235.bak to E:\Backup_sera_AutoPlus\Autoplus201201311235.zip
31/01/2012 12:35:18 Compression completed (archive size: 2.861 KB)
31/01/2012 12:35:18 Removing the backup: C:\temp\Autoplus201201311235.bak
31/01/2012 12:35:18 Uploading E:\Backup_sera_AutoPlus\Autoplus201201311235.zip to ftp://87.12.65.170:21/
31/01/2012 12:35:39 WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21
31/01/2012 12:35:40 Trying to upload again...
31/01/2012 12:36:01 WARNING: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21
31/01/2012 12:36:02 Trying to upload again...
31/01/2012 12:36:23 ERROR: Upload failed: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 87.12.65.170:21

Tanks.
Back to top
  |
AlexP
#6 Posted : Wednesday, April 11, 2012 2:39:19 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 175
Hi,

We did a change to improve uploading large files a short time ago (the application uses temporary file to upload). Although it doesn't have ability to change FTP timeout parameter now, could you please upgrade SQLBackupAndFTP to the latest release (6.5.8) and try again?
Back to top
 Report Abusive | Report SPAM
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.