Error: The database [filepath] is in use in single-user mode. (263) - when copying live to demo database

Error: The database [filepath] is in use in single-user mode. (263) - when copying live to demo database

Article summary

Did you find this summary helpful?

Thank you for your feedback

An error occurs when manually running the copy live to demo shortcut on the server.

** The database c:\npo\demo\dbfiles\found is in use in single-user mode. (263)

Steps To Duplicate:

Answer:

Many times this is caused by the _dbutil.exe utility holding onto the Demo database files and thus not allowing them to be updated or to start.

In Windows, open the task manager.
Go to the Processes tab
Look for a process called _dbutil.exe. (It may be visible on the details tab if not on the processes tab)
To verify, right click on the _dbutil.exe process and select Open file location
You should be directed to the _dbutil.exe in \npo\dlc\bin
After verifying that, go back to task manager, click on the _dbutil.exe process and then click the End Process button on the bottom
Run the Copy Live to Demo task again and it should be successful and the database should start during that process
After that process is finished, have users log into the Test\Demo database to be sure it is functional

Was this article helpful?