JET_errFileAccessDenied

Solved/Closed
NeilCairns Posts 2 Registration date Sunday June 5, 2016 Status Member Last seen June 24, 2016 - Jun 12, 2016 at 02:29 PM
NeilCairns Posts 2 Registration date Sunday June 5, 2016 Status Member Last seen June 24, 2016 - Jun 24, 2016 at 10:39 AM
Hello,
I'm trying to put a restored EDB in to a clean shutdown state (its currently saying its in a dirty shutdown state). However when I run the command I get this back;

Operation terminated with error -1032 (JET_errFileAccessDenied, Cannot access file, the file is locked or in use) after 30.93 seconds.
If I use handle.exe to show the handles for objects in use then that recovered EDB doesn’t appear in the list. The main EDB does but this recovered one (that will be part of a recovery group) doesn't.
There's no AV installed (I removed it to see whether this was causing the issue though it did have an EDB exclusion).
Any ideas what may be the cause?



2 responses

henriksen Posts 2 Registration date Sunday June 19, 2016 Status Member Last seen June 24, 2016 1
Jun 24, 2016 at 10:34 AM
1
henriksen Posts 2 Registration date Sunday June 19, 2016 Status Member Last seen June 24, 2016 1
Jun 21, 2016 at 12:07 PM
I think it is the log file that is locked. You might try a few things- cheating by moving the log files to another location and only leaving the essential log files or checking the properties on the log files. Or you can try to restore the file from backup. Always make a copy of your edb files before running any maintenance on them.
0
NeilCairns Posts 2 Registration date Sunday June 5, 2016 Status Member Last seen June 24, 2016
Jun 24, 2016 at 10:39 AM
Thank you buddy for your help and time. your recommendations are very useful. the issue is resolved.
0