We have a very important database on a network share that is used on a regular basis. The problem is that despite telling users they still leave the DB open when they leave for the day or for lunch etc. The workstation then locks and in turn locks the DB.
As the data is constantly changing I have a program that backs it up every hour providing it's not in use and then in the evening when everybody has gone home.
Is there any way I can force the DB to unlock?
If the DB is locked is it good practice to backup the .ldb. is this as reliable as backing up while the db is not locked?
Is it possible to close DB if it has not been used for say 10 mins?
Currently i created a VB app to back up the DB if the .ldb is not present.