Copy Command is Deleting Files
I am performing a SQL backup and copy between servers using bat files and Task Scheduler.
I create the backup files, then copy them from one server to another. The copy command copies all existing files; I use clear commands to remove older files.
The backup is working properly, but the copy command is deleting existing files selectively on the receiving server. For example, a file from1/1/2013 is there on 1/2, but missing on 1/7. Other files from the same day remain.
I have disabled the clear commands, so how is the copy command deleting files?
Backup-a.xlsx
I create the backup files, then copy them from one server to another. The copy command copies all existing files; I use clear commands to remove older files.
The backup is working properly, but the copy command is deleting existing files selectively on the receiving server. For example, a file from1/1/2013 is there on 1/2, but missing on 1/7. Other files from the same day remain.
I have disabled the clear commands, so how is the copy command deleting files?
Backup-a.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When the batch file runs that does the copy, does it ever report any errors from the copy command? If not I'd be surprised if it was deleting the files.
You might want to add a DIR of the destination folder at the start and end of the BAT file to try and see if the files go missing as a result of it running.
~bp
You might want to add a DIR of the destination folder at the start and end of the BAT file to try and see if the files go missing as a result of it running.
~bp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What are the names of these files, naming rules--is it possible old and new files have the same names and so when copied replace an existing?
ASKER
I will try the auditing.
So, just curious, what was the source of the disappearing files, and how did you resolve it?
~bp
~bp
ASKER
I have not figured out the problem, so we are going to monitor the situation and see what happens. if we discover the cause, I will post it.
ASKER
Is it possible that intermittent transmission errors in the midst of the copy/overwrite of existing files are deleting existing files without successfully replacing them?