Database requires update to version when running database restore

Purpose

You are receiving the error "Database requires update to version ##.#.#.#" when attempting to run the database restore command in Deploy or Inventory.

Resolution

The services can become stuck with corrupt databases, causing the commands to fail, stopping the services, renaming the database files, and starting the services, will create new database files which should not interfere with command execution.

1. Stop the service pertaining to the application.
   • net stop PDQDeploy
   • net stop PDQInventory
2. Browse to the directory pertaining to the application.
   • C:\ProgramData\Admin Arsenal\PDQ Deploy
   • C:\ProgramData\Admin Arsenal\PDQ Inventory
3. Rename the "database.db" and "log.db" to ".old".
4. Start the service pertaining to the application.
   • net start PDQDeploy
   • net start PDQInventory
5. Run the database restore command pertaining to the application.
   • pdqdeploy restoredatabase
   • pdqinventory restoredatabase