SQL 2000 or SQL 2005 user database restore fails with the error "Exclusive access could not be obtained because the database is in use" when single user mode is already set on the database that is being restored to.
0x00008492 - Database query failure. See the job log for details.
An Error occurred on a query to database.
V-79-65323-3101 - Exclusive access could not be obtained because the database is in use.
-This error occurres if there are any active connections to the SQL database are open.
-When the database is in single user mode and the SQL utility was open while attepting the restore job.
1. Verify that single user mode is set in the properties of the database that the data will be restored to (Figure 1)
2. Verify that all SQL utilities such as Enterprise Manager, and Query Analyzer are closed
3. Now run the restore job
2. Run the Restore Job.