Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
2 Pages 12>
New Topic Post Reply
The FTP command execution timed-out. Options · View
Previous Topic · Next Topic
Zolf
#1 Posted : Tuesday, December 01, 2009 12:35:33 AM Quote
Rank: Guest

Groups: Registered

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

I have been having problem sending db backup via FTP lately. it used to work fine until i updated to the latest version.i get this error.i asked my hosting company what ftp they use and they told me it is microsoft ftp.my db size is around 45MB.please help

>>> run 12/1/2009 9:54:13 AM by administrator

SqlBackupAndFtp 4.0.1.40326 (Free)

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

DETAILED LOG:
12/1/2009 9:48:29 AM Creating backup of Po
12/1/2009 9:48:43 AM Backup of Po completed
12/1/2009 9:48:43 AM Zipping C:\WINDOWS\TEMP\eacdhnc0.22s\Po200912010948.bak to F:\DBBackup\Po200912010948.zip
12/1/2009 9:48:48 AM Zip completed (compressed size: 7,311 Kb)
12/1/2009 9:48:48 AM Removing the backup: C:\WINDOWS\TEMP\eacdhnc0.22s\Po200912010948.bak
12/1/2009 9:48:48 AM Uploading F:\DBBackup\Po200912010948.zip to ftp://melsot.com:21/DBBackup
12/1/2009 9:53:37 AM ERROR: Upload failed: The FTP command execution timed-out.
12/1/2009 9:53:37 AM Removing temporary folder C:\WINDOWS\TEMP\eacdhnc0.22s
12/1/2009 9:53:37 AM Cleaning ftp://melsot.com:21/DBBackup
12/1/2009 9:53:58 AM WARNING: Cleaning failed: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host
12/1/2009 9:53:58 AM Sending a confirmation e-mail (Failure) to zj@gmail.com (SMTP)
12/1/2009 9:54:13 AM ERROR: Sending a confirmation e-mail failed: Failure sending mail. The remote name could not be resolved: 'smtp.gmail.com'
12/1/2009 9:54:13 AM ERROR: Job finished (With Errors)


>>> run 11/30/2009 8:02:11 PM by SYSTEM

SqlBackupAndFtp 4.0.1.40326 (Free)

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

DETAILED LOG:
11/30/2009 8:00:00 PM Creating backup of Po
11/30/2009 8:00:16 PM Backup of Po completed
11/30/2009 8:00:16 PM Zipping C:\WINDOWS\TEMP\a2a5deef.s2r\Po200911302000.bak to F:\DBBackup\Po200911302000.zip
11/30/2009 8:00:20 PM Zip completed (compressed size: 7,314 Kb)
11/30/2009 8:00:20 PM Removing the backup: C:\WINDOWS\TEMP\a2a5deef.s2r\Po200911302000.bak
11/30/2009 8:00:20 PM Uploading F:\DBBackup\Po200911302000.zip to ftp://melsot.com:21/DBBackup
11/30/2009 8:01:35 PM ERROR: Upload failed: The FTP command execution timed-out.
11/30/2009 8:01:35 PM Removing temporary folder C:\WINDOWS\TEMP\a2a5deef.s2r
11/30/2009 8:01:35 PM Cleaning ftp://melsot.com:21/DBBackup
11/30/2009 8:01:57 PM WARNING: Cleaning failed: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host
11/30/2009 8:01:57 PM Sending a confirmation e-mail (Failure) to zj@gmail.com (SMTP)
11/30/2009 8:02:11 PM ERROR: Sending a confirmation e-mail failed: Failure sending mail. The remote name could not be resolved: 'smtp.gmail.com'
11/30/2009 8:02:11 PM ERROR: Job finished (With Errors)
Back to top
  |
mikeshilov
#2 Posted : Tuesday, December 01, 2009 12:45:49 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Zolf,

what version did you use before?
Back to top
 Report Abusive | Report SPAM | Edit by user: Tuesday, December 01, 2009 12:50 AM | Reason: Not specified
Guest
#3 Posted : Tuesday, December 01, 2009 12:56:03 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
Zolf,

what version did you use before?


i think it was 3.2.2.but i am not sure.it has been nearly 2 months
Back to top
  |
Guest
#4 Posted : Tuesday, December 01, 2009 12:57:46 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
Zolf,

what version did you use before?



Now i am using 4.0.1.40326
Back to top
  |
Guest
#5 Posted : Tuesday, December 01, 2009 1:03:10 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
Guest wrote:
mikeshilov wrote:
Zolf,

what version did you use before?


i think it was 3.2.2.but i am not sure.it has been nearly 2 months



yes i was correct. i used the above mentioned version and it was working fine, then i upgraded to 3.4.3 and i had problem with this version,then i again upgraded to the version 4... but still i have the problem.
Could the problem be related to the db size.when i was first using that 3.2.2 version my db size was small
Back to top
  |
mikeshilov
#6 Posted : Tuesday, December 01, 2009 1:11:22 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Yes it could be related to db size, can you check it now with a smaller db?
Back to top
 Report Abusive | Report SPAM
Guest
#7 Posted : Tuesday, December 01, 2009 1:14:37 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
Yes it could be related to db size, can you check it now with a smaller db?


OK
Back to top
  |
Guest
#8 Posted : Tuesday, December 01, 2009 3:31:00 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
Yes it could be related to db size, can you check it now with a smaller db?



i tried with a small db which when zipped was 1,148 Kb,but still i get this error.i think something is wrong.it is not related to size too


>>> run 12/1/2009 12:56:25 PM by administrator

SqlBackupAndFtp 4.0.1.40326 (Free)

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

DETAILED LOG:
12/1/2009 12:53:21 PM Creating backup of testsql
12/1/2009 12:53:27 PM Backup of testsql completed
12/1/2009 12:53:27 PM Zipping C:\WINDOWS\TEMP\5d0scigp.tqm\testsql200912011253.bak to F:\DBBackup\testsql200912011253.zip
12/1/2009 12:53:27 PM Zip completed (compressed size: 1,148 Kb)
12/1/2009 12:53:27 PM Removing the backup: C:\WINDOWS\TEMP\5d0scigp.tqm\testsql200912011253.bak
12/1/2009 12:53:27 PM Uploading F:\DBBackup\testsql200912011253.zip to ftp://mt.com:21/DBBackup
12/1/2009 12:55:49 PM ERROR: Upload failed: The FTP command execution timed-out.
12/1/2009 12:55:49 PM Removing temporary folder C:\WINDOWS\TEMP\5d0scigp.tqm
12/1/2009 12:55:49 PM Cleaning ftp://mft.com:21/DBBackup
12/1/2009 12:56:22 PM Sending a confirmation e-mail (Failure) to zji@gmail.com (SMTP)
12/1/2009 12:56:25 PM Confirmation e-mail (Failure) has been successfully sent
12/1/2009 12:56:25 PM ERROR: Job finished (With Errors)
Back to top
  |
mikeshilov
#9 Posted : Tuesday, December 01, 2009 3:34:47 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
The problem is that we're still not able to reproduce this error on our side.
Can anyone present us a temporary account on your FTP server for testing?

BR,
Mike
Back to top
 Report Abusive | Report SPAM
Guest
#10 Posted : Tuesday, December 01, 2009 3:46:31 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
The problem is that we're still not able to reproduce this error on our side.
Can anyone present us a temporary account on your FTP server for testing?

BR,
Mike


i can create a temp acount on my ftp.but if you provide me with some email,as i cannot post the details here.
one weird think i noticed was that i get that error message inthe log of sqlbackupandftp and via email.but now when i wanted to create the ftp for you.i noticed that the backup of my db was in the folder.
Back to top
  |
mikeshilov
#11 Posted : Tuesday, December 01, 2009 3:59:36 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Guest wrote:
i can create a temp acount on my ftp.but if you provide me with some email,as i cannot post the details here.one weird think i noticed was that i get that error message inthe log of sqlbackupandftp and via email.but now when i wanted to create the ftp for you.i noticed that the backup of my db was in the folder.


you can write at support[at]sqlbackupandftp[dot]com
Back to top
 Report Abusive | Report SPAM
csiegers
#12 Posted : Wednesday, December 30, 2009 4:26:23 AM Quote
Rank: Newbie

Groups: Registered

Joined: 12/30/2009
Posts: 1
i have got exactly the same probleem. When uploading more than 1 database, the first one fails always, the other uploads will go good.

The exception message is the same as above.
Back to top
 Report Abusive | Report SPAM | Edit by user: Wednesday, December 30, 2009 12:02 PM | Reason: Not specified
alex
#13 Posted : Wednesday, January 13, 2010 1:20:26 PM Quote
Rank: Administration

Groups: Registered

Joined: 8/10/2009
Posts: 143
Guys, please try to use version 4.3
Change log:


* Fixed bug related to Xceed.Ftp.FtpTimeoutException
* Fixed bug related to cleaning of old files (wrong date format)

You can download the program from here
Back to top
WWW  Report Abusive | Report SPAM | Edit by user: Wednesday, January 13, 2010 1:21 PM | Reason: Not specified
Kev
#14 Posted : Tuesday, January 19, 2010 5:35:27 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
I have tried your new version 4.3 but I receive a time out error.

My max compressed DB is 35Mb which transfers to the FTP site and is still sending after 6 mins, I tested a small DB compressed to 2Mb and this transfers fine with no errors.

After looking into the issue, I don't know if you can do this but with other FTP software they send out a 'keep alive command' to avoid this time out error!

7z is a great compression application could you enable this as a default compression, my compressed file at 35Mb uncompressed is 225Mb where as 7z compressed is 17Mb.

Thanks for the great work.

Kev
Back to top
  |
Kev
#15 Posted : Tuesday, January 19, 2010 6:15:28 AM Quote
Rank: Newbie

Groups: Registered

Joined: 1/19/2010
Posts: 3
Location: East Yorkshire
Would the following command be a solution to keep the command line open ?

"NOOP" is a special FTP command that does nothing, but lets an FTP server know that you're still there and that you'd like to stay connected to the FTP server. By NOOPing an FTP server every so often, you can keep your FTP connection alive otherwise known as "Keep Alive" which usually has preferences and setting "Poll" to the number of seconds between each FTP NOOP command.

I hope this is of some help towards a solution.

Regards
Kev
Back to top
 Report Abusive | Report SPAM
mikeshilov
#16 Posted : Tuesday, January 19, 2010 6:23:35 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Kev,

Could you please enable FTP logging (in FTP settings dialog) and send us a log of the error case.

BR,
Mike
Back to top
 Report Abusive | Report SPAM
Kev
#17 Posted : Tuesday, January 19, 2010 8:36:57 AM Quote
Rank: Newbie

Groups: Registered

Joined: 1/19/2010
Posts: 3
Location: East Yorkshire
Mike,

I've sent you the log files via the website email.

Thanks Kev
Back to top
 Report Abusive | Report SPAM
Guest
#18 Posted : Thursday, January 28, 2010 8:41:03 AM Quote
Rank: Guest

Groups: Registered

Joined: 8/10/2009
Posts: 725
I am having a similar issue. The weird thing is that everything seems to be completing correctly, it just says that it doesn't.

Here is the log:
>>> run 1/28/2010 9:08:12 AM by administrator

SqlBackupAndFtp 4.3.0.32657 (Free)

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

DETAILED LOG:
1/28/2010 8:22:23 AM Creating backup of P21Play to C:\Windows\TEMP
1/28/2010 8:22:59 AM Backup of P21Play completed
1/28/2010 8:22:59 AM Zipping C:\Windows\TEMP\P21Play201001280822.bak to C:\Windows\TEMP\P21Play201001280822.zip
1/28/2010 8:26:17 AM Zip completed (compressed size: 421,436 Kb)
1/28/2010 8:26:17 AM Removing the backup: C:\Windows\TEMP\P21Play201001280822.bak
1/28/2010 8:26:17 AM Uploading C:\Windows\TEMP\P21Play201001280822.zip to ftp://superfiles.myftp.org:51100/
1/28/2010 9:08:06 AM ERROR: Upload failed: The FTP command execution timed-out.
1/28/2010 9:08:06 AM Removing C:\Windows\TEMP\P21Play201001280822.zip
1/28/2010 9:08:07 AM Cleaning ftp://superfiles.myftp.org:51100/
1/28/2010 9:08:11 AM Sending a confirmation e-mail (Failure) to jon@nemic.net (SMTP)
1/28/2010 9:08:12 AM Confirmation e-mail (Failure) has been successfully sent
1/28/2010 9:08:12 AM ERROR: Job finished (With Errors)

The entire file is uploaded to my FTP, but then it says that the FTP command execution timed-out. I have my FTP server set to never timeout.

Any idea why this is happening?
Back to top
  |
alex
#19 Posted : Friday, January 29, 2010 10:28:41 AM Quote
Rank: Administration

Groups: Registered

Joined: 8/10/2009
Posts: 143
Please send us the log with FTP log details.

1. Enable FTP Settings->Write FTP Session to log
2. Repeat your action

P.S you can use Contact form to provide us this information
Back to top
WWW  Report Abusive | Report SPAM | Edit by user: Friday, January 29, 2010 10:30 AM | Reason: Not specified
Kev
#20 Posted : Wednesday, February 10, 2010 4:21:14 AM Quote
Rank: Newbie

Groups: Registered

Joined: 1/19/2010
Posts: 3
Location: East Yorkshire
Version 4.3 installed, still error reporting the same:

"ERROR: Upload failed: The FTP command execution timed-out."

The file compression could be better with 7z which might help the 'time-out' in sending the file. Could this be the easiest solution ?
Back to top
 Report Abusive | Report SPAM
Quick Reply Show Quick Reply
2 Pages 12>
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.