August 28, 2018 at 4:32 am
Hi all,
We scheduled a refresh from Prod to UAT over the weekend and now get the following, error, advice appreciate:
08/26/2018 20:09:07,MSSQLSERVER,Error,BackupDiskFile::OpenMedia: Backup device '\\BHS-Storage02\DPMSQLMigrations\MyDBName_diff.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).,(2),18204,BHS-ADS\svcSTAGE16SqlAgent,ServerName
08/26/2018 20:08:55,MSSQLSERVER,Information,The database MyDBName' is marked RESTORING and is in a state that does not allow recovery to be run.,(2),3402,BHS-ADS\svcSTAGE16SqlAgent,ServerName
TIA
August 28, 2018 at 4:54 am
You haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.
August 28, 2018 at 5:10 am
Beatrix Kiddo - Tuesday, August 28, 2018 4:54 AMYou haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.
Nope
August 28, 2018 at 8:42 am
JackCarrington - Tuesday, August 28, 2018 5:10 AMBeatrix Kiddo - Tuesday, August 28, 2018 4:54 AMYou haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.Nope
There are quite a few ways to find what process has a lock on a file -
Resource Monitor:
How to Use Resource Monitor to Find Which Process Has Locked a File?
Process Explorer:
How do you find what process is holding a file open in Windows?
Powershell:
How to find out which process is locking a file or folder in Windows by PowerShell
And others:
How do you find what process is holding a file open in Windows?
Sue
August 28, 2018 at 8:55 am
Sue_H - Tuesday, August 28, 2018 8:42 AMJackCarrington - Tuesday, August 28, 2018 5:10 AMBeatrix Kiddo - Tuesday, August 28, 2018 4:54 AMYou haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.Nope
There are quite a few ways to find what process has a lock on a file -
Resource Monitor:
How to Use Resource Monitor to Find Which Process Has Locked a File?
Process Explorer:
How do you find what process is holding a file open in Windows?
Powershell:
How to find out which process is locking a file or folder in Windows by PowerShell
And others:
How do you find what process is holding a file open in Windows?Sue
Awesome and thanks Sue for compiling all the possible ways in a single place. I usually go with process explorer, but it's really nice to know other alternatives. Added to my briefcase, thanks again 🙂
August 28, 2018 at 10:40 am
Sreekanth B - Tuesday, August 28, 2018 8:55 AMSue_H - Tuesday, August 28, 2018 8:42 AMJackCarrington - Tuesday, August 28, 2018 5:10 AMBeatrix Kiddo - Tuesday, August 28, 2018 4:54 AMYou haven't got any antivirus scans running, have you? .baks would usually be excluded but it's worth checking.Nope
There are quite a few ways to find what process has a lock on a file -
Resource Monitor:
How to Use Resource Monitor to Find Which Process Has Locked a File?
Process Explorer:
How do you find what process is holding a file open in Windows?
Powershell:
How to find out which process is locking a file or folder in Windows by PowerShell
And others:
How do you find what process is holding a file open in Windows?Sue
Awesome and thanks Sue for compiling all the possible ways in a single place. I usually go with process explorer, but it's really nice to know other alternatives. Added to my briefcase, thanks again 🙂
You and me both - I love using process explorer. And access denied = process monitor. 🙂
Great tools but in some locked down environments you unfortunately have to come up with other ways.
Sue
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply