I’m trying to backup database files (resided in the C: drive in ‘Program Files’ area) from the Microsoft SQL 2008 ‘data’ folder to a backup folder in the D: drive - using ‘xcopy’ (in a batch command file) but encountered “sharing violation” message (reported in command prompt windows).
The backup files in the D: drive will be backup to an external hard drive for safe keeping (as one backup strategy).
I’m running Windows server 2008R.
I have administrative rights. What is coursing this sharing violation and how can fix this issue?
Any help would be appreciated.