May 26, 2016 at 4:56 am
Dear All,
I have a database which is set t "Read-only/Standby) where I have a transactional log backup gets restored, it has been working fine until recently when it keeps throwing the following error message:
The operating system error was '32(The process cannot access the file because it is being used by another process.)
I have done the following so far but I'm not sure what else could be causing the issue.
Checked if there are other processes which are running in sql management studio
2. Checked if the is an anti-virus trying to scan the folder
There does not seem to be any processes so would anyone let me know what the cause of the issue is please?
Thank you in advance!
May 26, 2016 at 9:25 am
To see what is using the file
http://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows
To use a batch command to make a new copy of the file even if it is in use.
http://stackoverflow.com/questions/7647701/how-to-copy-in-use-files-through-batch-file-in-windows-7
May 26, 2016 at 9:31 am
So you see that error message when you attempt to do the restore? Please will you post the RESTORE statement that you're running?
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply