Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
SQL BackupAndFTP too slow Options · View
Guest
#1 Posted : Thursday, July 29, 2010 10:28:09 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 609
I am trying to backup a 2 GB database and its very very slow. Its been more than 1.5 hours and and finally failed.
this is the log file

SqlBackupAndFtp 5.0.3.31844 (Free)

SUMMARY:
Database P71_d_old: Backup - Success, FTP - Failure Folder backup: Zip - Success, FTP - Failure

DETAILED LOG:
7/29/2010 9:59:03 AM Creating backup of P71_d_old to D:\backup
7/29/2010 9:59:39 AM Backup of P71_d_old completed
7/29/2010 9:59:39 AM Zipping D:\backup\P71_d_old201007290959.bak to D:\backup\P71_d_old201007290959.zip
7/29/2010 10:02:30 AM Zip completed (compressed size: 341,277 Kb)
7/29/2010 10:02:30 AM Removing the backup: D:\backup\P71_d_old201007290959.bak
7/29/2010 10:02:30 AM Uploading D:\backup\P71_d_old201007290959.zip to ftp://ftp.ihs-support.org:21/ihs/Aatish/P71
7/29/2010 10:18:07 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
7/29/2010 10:18:08 AM Trying to upload again...
7/29/2010 10:18:09 AM WARNING: Request: STOR P71_d_old201007290959.zip
Response: 550 P71_d_old201007290959.zip: The process cannot access the file because it is being used by another process.

7/29/2010 10:18:10 AM Trying to upload again...
7/29/2010 10:18:12 AM ERROR: Upload failed: Request: STOR P71_d_old201007290959.zip
Response: 550 P71_d_old201007290959.zip: The process cannot access the file because it is being used by another process.

7/29/2010 10:18:12 AM Removing P71_d_old201007290959.zip from D:\backup
7/29/2010 10:18:12 AM Starting folder backup
7/29/2010 10:18:12 AM Zipping D:\backup to D:\backup\backup201007291018.zip
7/29/2010 10:23:09 AM Zip completed (compressed size: 816,990 Kb)
7/29/2010 10:23:09 AM Uploading D:\backup\backup201007291018.zip to ftp://ftp.ihs-support.org:21/ihs/Aatish/P71
7/29/2010 11:08:38 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
7/29/2010 11:08:39 AM Trying to upload again...
7/29/2010 11:08:41 AM WARNING: Request: STOR backup201007291018.zip
Response: 550 backup201007291018.zip: The process cannot access the file because it is being used by another process.

7/29/2010 11:08:42 AM Trying to upload again...
7/29/2010 11:08:43 AM ERROR: Upload failed: Request: STOR backup201007291018.zip
Response: 550 backup201007291018.zip: The process cannot access the file because it is being used by another process.

7/29/2010 11:08:43 AM Removing backup201007291018.zip from D:\backup
7/29/2010 11:08:43 AM Cleaning ftp://ftp.ihs-support.org:21/ihs/Aatish/P71

Guest
#2 Posted : Thursday, July 29, 2010 10:30:44 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 609
and yes on the ftp it created two zip folders
backup201007291018.zip----67MB
P71_d_old201007290959.zip.----- 22MB

I don't know why two folders. any idea?
mikeshilov
#3 Posted : Friday, July 30, 2010 8:15:16 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 255
the first zip is your "D:\backup" folder
the second is you P71_d_old database
FTP transfer took the main time (because your zip files are quite big) and failed because of problems with your FTP server
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.