Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
FTP - Failure Options · View
Previous Topic · Next Topic
artsr2002
#1 Posted : Friday, March 25, 2011 8:27:00 AM Quote
Rank: Newbie

Groups: Registered

Joined: 3/25/2011
Posts: 1
I have tried uploading a couple of databases to ftp.adrive.com and when I get the success/failure email, this is what it shows...even though one of the databases, the first one, seems to have uploaded fine. Is this a problem with adrive or is it on my end or is it the SQLBackupandFTP app??? Thanks for your help.

SqlBackupAndFtp 5.5.0.28925 (Free)

SUMMARY:
Database TopsData: Backup - Success, FTP - Failure
Database TopsFDB: Backup - Success, FTP - Failure

DETAILED LOG:
3/24/2011 7:35:02 PM Creating backup of TopsData to D:\TEMPORARY
3/24/2011 7:42:16 PM Backup of TopsData completed
3/24/2011 7:42:16 PM Zipping D:\TEMPORARY\xxxxx.bak to E:\Daily DB Backup\xxxxx.zip
3/24/2011 8:16:26 PM Zip completed (compressed size: 4,076,746 Kb)
3/24/2011 8:16:26 PM Removing the backup: D:\TEMPORARY\xxxxx.bak
3/24/2011 8:16:26 PM Uploading E:\Daily DB Backup\xxxxx.zip to ftp://ftp.adrive.com:21/
3/25/2011 7:18:09 AM Upload of E:\Daily DB Backup\xxxxx.zip completed
3/25/2011 7:18:31 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 38.111.148.80:21
3/25/2011 7:18:32 AM Trying to get file size again...
3/25/2011 7:18:52 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 38.111.148.80:21
3/25/2011 7:18:53 AM Trying to get file size again...
3/25/2011 7:19:14 AM ERROR: Remote file size verification 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 38.111.148.80:21

3/25/2011 7:19:14 AM Creating backup of TopsFDB to D:\TEMPORARY
3/25/2011 7:19:34 AM Backup of TopsFDB completed
3/25/2011 7:19:34 AM Zipping D:\TEMPORARY\xxxxx.bak to E:\Daily DB Backup\xxxxx.zip
3/25/2011 7:22:13 AM Zip completed (compressed size: 283,078 Kb)
3/25/2011 7:22:13 AM Removing the backup: D:\TEMPORARY\xxxxx.bak
3/25/2011 7:22:13 AM Uploading E:\Daily DB Backup\xxxxx.zip to ftp://ftp.adrive.com:21/
3/25/2011 7:22:34 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 38.111.148.80:21
3/25/2011 7:22:35 AM Trying to upload again...
3/25/2011 7:22:56 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 38.111.148.80:21
3/25/2011 7:22:57 AM Trying to upload again...
3/25/2011 7:23:18 AM 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 38.111.148.80:21
3/25/2011 7:23:18 AM Cleaning ftp://ftp.adrive.com:21/
3/25/2011 7:23:39 AM WARNING: Cleaning 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 38.111.148.80:21
3/25/2011 7:23:39 AM Cleaning E:\Daily DB Backup
Back to top
 Report Abusive | Report SPAM
ruslan
#2 Posted : Friday, March 25, 2011 12:07:05 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
So, uploading 4 GB to FTP server fails. It is hard to know what particular piece is responsible for the problem, but given the size of the upload, it is hardly surprising. First I would try changing connection to Active in Advanced FTP settings. Then, if it doesn't help, I would try a different FTP server if possible.
But generally I would not rely on FTP for transferring 4GB of data. We are working on adding Dropbox and S3 as transfer targets. But until we have these features, the safest bet for large backups is to store them on the network drive if FTP fails.
Back to top
 Report Abusive | Report SPAM | Edit by user: Friday, March 25, 2011 12:07 PM | Reason: Not specified
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.