Problems Restoring a Database from a Backup
PROBLEM
When I try restoring from a database that I have previously backed up I get the following error messages:
'Could not drop database - either you don't have the rights to do this or there are other users logged in'
Then
'Lock time-out on wait transaction. Object C:\Database\<database name> is in use'
CAUSE
There are two reasons that you may be having this problem:
- You are not logged into the Ascent program as SYSDBA (this user is the default system administrator with full access permissions). Only the user SYSDBA has the necessary permissions to 'drop' and 'recreate' a database (which is what happens when you do a restore).
OR
- There may be other people logged into the database or you may have the Online Manager or AscentWatcher programs running on the database.
SOLUTION
- Find the person who can log in as SYSDBA (probably your system administrator) and ask them to perform the database restore.
- Make sure that there are no people or programs using the database when you try to do the restore.
FAQ ID: 16356 Last Reviewed: 25 November 2005