4,707 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The error is "Sharing violation". The file appears to be in use by something and cannot be overwitten.
The step was retried the requested number of times (5) without succeeding.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 20%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HP1979
26
Reputation points
We have one schedule job which is copying the backup to the offsite server through xcopy. This job successfully run for 4-5 days in a week and failed for 1-2 days due to following error.
Executed as user: service_Account. The step was retried the requested number of times (5) without succeeding. The step failed.
Sharing violation.
Any help would be greatly appreciate!
Developer technologies | Transact-SQL
{count} votes
-
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator2022-02-22T22:43:05.357+00:00 On the Advanced tab for the job step, define an output file, and set it to append to the file. When the job fails, check the file. What you see in the job history is very limited.
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LiHong-MSFT 10,056 Reputation points2022-02-24T03:34:33.863+00:00 Hi @HP1979
Sharing violation happens when another other program has the file locked up (another program is currently using/accessing the file).
Or maybe the directory on offsite server( copying to) had files which you could not write over.
Here is a thread which may help you: False 'Sharing Violation' Xcopy error messageBest regards,
LiHong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.