By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,190 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,190 IT Pros & Developers. It's quick & easy.

How to unlock database

Expert 100+
P: 181
I have an application with data on the server. Sometimes this data file remains locked even after all users exited the applcation. So the only option now is to restart the server, which is undesireble.
The question is if there is another way to unlock the data file, whithout restarting the server ?
Oct 29 '06 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,494
First look at the LDB file (Just use Type MyDB.Ldb or whatever from the 'Command Prompt' or from 'Run') to see who has it locked.
Check carefully all entries in the list (sometimes it is open by people or PCs you wouldn't expect.
When you've cleared these all down and it still has entries (possible as it doesn't handle some crashes v well) then you need to look at unlocking the file from an OS point of view.

This gets a bit technical so hold on.
Open 'Computer Manager' from the Admin Tools folder.
If it's not stored on the local PC but a server somewhere then right-click on the top line 'Computer Management (local) and 'Connect to another computer...'. Select the server from the Browse list.
Select 'Shared Folders' then 'Open Files'.
Find the LDB file in the list then, from the right-click menu, select 'close'.
When the file is no longer in the list (F5 to refresh), delete the LDB file.

That should free it up for you.

If you get stuck on any of this then post back here explaining where and I'll try to clarify.
Oct 29 '06 #2

Expert 100+
P: 181
Thanks, NeoPa. It works like a magic !
But, although a great improvement from restarting the server, still looking for something better. So my next questions are:
1. Is there any way to automate this process of ldb release ? It can be quite difficult to explain the customer about this computer manager thing.
2. Is it possible to do something without accessing the server directly ? The customer may not have that access.
Oct 30 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.