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?