[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Copy Command is Deleting Files

Posted on 2013-01-07
8
Medium Priority
?
373 Views
Last Modified: 2013-01-08
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
0
Comment
Question by:fhcdaver
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 34

Assisted Solution

by:Paul MacDonald
Paul MacDonald earned 1500 total points
ID: 38752649
And no human has access to the place where the files are being copied?  No other process deletes files from there?  

I'd turn on auditing and see who's doing what.
0
 

Author Comment

by:fhcdaver
ID: 38752793
I'm confident no person is doing it, and don't see any other processes.  

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?
0
 
LVL 57

Expert Comment

by:Bill Prew
ID: 38753281
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
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 34

Accepted Solution

by:
Paul MacDonald earned 1500 total points
ID: 38754687
"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?"
I don't see how.  Moreover, if you're sure the files exist at some point, then are deleted, I fail to see how the copy command could be responsible for that.  

Is there a separate clean-up process?  Are you unwilling or unable to audit file access/permission use to see when these files are being deleted?
0
 
LVL 25

Expert Comment

by:Lionel MM
ID: 38754715
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?
0
 

Author Closing Comment

by:fhcdaver
ID: 38755201
I will try the auditing.
0
 
LVL 57

Expert Comment

by:Bill Prew
ID: 38755386
So, just curious, what was the source of the disappearing files, and how did you resolve it?

~bp
0
 

Author Comment

by:fhcdaver
ID: 38756904
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.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of my most closely kept secrets is revealed in this discussion How to output text on the same line This question was recently posted in EE by Simon336697 (http://www.experts-exchange.com/Programming/Languages/Scripting/Shell/Batch/Q_2459…
Being a system administrator some time we require to do things remotely, one of them is installing software. Here I am going to tell you how to install software through wmic (Windows management instrument console). I am not at all saying that this i…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question