FTP Error:550 File already exists.

[davidizadar]

Hi,

We are using BestSync 2012 for protecting our SQL Server backups to a local NAS and two remote locations (one FTP Server and one Amazon S3 Bucket).
In SQL Server we create weekly full backups, daily differential backups, and hourly transaction log backups for each database.
As we want to keep track of everything, we are also interested in sending the transfer logs to the remote locations.

Of course, we don't need a full synchronization, as we will keep a 30 days remote backup of our files.
So, all our transfers are going from left to right, compressing and encrypting in the first step (SQL Server backup directory to NAS).

We need to know if anything fails, and each task is configured for sending log files in case of failure.

That being said, when sending information to the FTP site, I'm always receiving emails reporting FTP Error 550 for some files.
Why?
If the file already exists, it should be ignored, it was already copied. If the local file is newer than the remote file, it should override it.

What am I doing wrong?

David Izada R

[RiseFly]

Because Error 550 is returned from the server, please check if you have set the correct privilege of the folder on the FTP server.

[davidizadar]

I was using Quick & Easy FTP Server with all the privileges.
Just in case, I'm testing now with Wing FTP Server, also with all the privileges.
I'll monitor the results.

David

[davidizadar]

Hi,

I was trying to understand the reason for these messages.
So, I started examining your logs (received by e-mail indicating failure), and your "local database" (files *.FSF, *.FSL, *.FSN, *.FSS, and service.TXT).
It looks like you create your own image of what should be in the FTP Server. Then, according to the local monitoring and configuration (how long to keep files in the FTP Server), you start a transfer 1 ==> 2 or you Delete a file in the FTP Server.

For example, here you try to transfer a bunch of files, but some of them are already in the FTP Server.
,Ver7.0.1.7
Wednesday, January 11, 2012 11:06:43 [==>Success:7 Failed:3 Completed Size:3,236]

C:\ZDrive\Transfer Logs\ ==> ftp://testbackup@ftp.denovosoftware.com/Transfer Logs/
Action,File,Time,Size,Result
1==>2,\MSSQL to ZDrive\TransferMSSQLtoZ20120111-110506.csv, 1/11/2012 11:05:06,465,Success
1==>2,\ZDrive to AmazonS3\ZtoAmazonS320120111-105258.csv, 1/11/2012 10:52:58,217,Success
1==>2,\ZDrive to FTP\TransferLogToFTP20120111-050701.csv, 1/11/2012 05:07:01,459,FTP Error:550 File already exists.
1==>2,\ZDrive to FTP\TransferLogToFTP20120111-073720.csv, 1/11/2012 07:37:20,847,FTP Error:550 File already exists.
1==>2,\ZDrive to FTP\TransferLogToFTP20120111-103741.csv, 1/11/2012 10:37:41,964,Success
1==>2,\ZDrive to FTP\ZDBBackupToFTP20120111-050544.csv, 1/11/2012 05:05:44,539,FTP Error:550 File already exists.
1==>2,\ZDrive to FTP\ZDBBackupToFTP20120111-104643.csv, 1/11/2012 10:46:43,352,Success
1==>2,\ZDrive to FTP\ZDBBackupToFTP20120111-105030.csv, 1/11/2012 10:50:30,476,Success
1==>2,\ZDrive to FTP\ZDBBackupToFTP20120111-105949.csv, 1/11/2012 10:59:49,500,Success
1==>2,\ZDrive to FTP\ZDBBackupToFTP20120111-110027.csv, 1/11/2012 11:00:27,262,Success
Success,7
Failed,3
Completed Size,3236

In this log you try to delete some files, but I started my second test with an empty directory and there is a different error.


,Ver7.0.1.7
Wednesday, January 11, 2012 10:59:49 [==>Success:0 Failed:2 Completed Size:0]

C:\ZDrive\Database Backups\ ==> ftp://testbackup@customerftp.denovosoft ... m/Database Backups/
Action,File,Time,Size,Result
Del 2,\Diff\DTI\DTI_backup_2011_12_12_104905_8276000.bak, 12/12/2011 10:49:08,1884823,FTP Error:550 Invalid file name
Del 2,\Log\DTI\DTI_backup_2011_12_12_105518_5226000.trn, 12/12/2011 10:55:30,12660848,FTP Error:550 Invalid file name
Success,0
Failed,2
Completed Size,0

What about listing the directory for synchronizing the internal database with the actual content of the FTP Server?

David

[davidizadar]

Sorry, these messages are not the result of permissions on the FTP Server, but because I checked the box about not doing a full synchronization, just looking at the source directory... The program has the right to infer that each copied file will be on the second directory...

David

[RiseFly]

Could you please send a test account to me (risefly(at)risefly.com)? so I can debug this problem.
BestSync uses a local file to remember the folder state of the last sync to detect the file deleting and moving, but it always scans the current state of folder to find changed files before synchronization.
Please start the preview of the task, and confirm the timestamp of the files that will be copied, are these timestamps different?

[RiseFly]

We have just released version 7.0.20, the new version has fixed the renaming problem.