Database Restore Required

Follow

Comments

6 comments

  • Jharper

    Database question.

     

    I am currently running PDQ deploy 2.2 Release 2 free mode......&  PDQ inventory 2.1.0 (build 2011) Pro mode... I would like to re-install this app and DB on a NEW server.. (basically migrate the Database to another server and work of that server from now on).

     

    Can you please list safe directions  how to do that with low risk of corrupting or losing the DB?

     

    thank you

    0
    Comment actions Permalink
  • Adam Ruth

    Certainly.  You will want to copy over the database directory and the system registry key.  The database for PDQ Deploy is:

    %ProgramData%\Admin Arsenal\PDQ Deploy

    And the system key is:

    HKEY_LOCAL_MACHINE\SOFTWARE\Admin Arsenal\PDQ Deploy

    PDQ Inventory is the same, just replace Deploy with Inventory.  If you're moving both just copy the Admin Arsenal directory and key.

    http://documentation.adminarsenal.com/PDQDeploy/2.2.2.0/data_files.htm

    http://documentation.adminarsenal.com/PDQInventory/2.1.0.3000/data_files.htm

    0
    Comment actions Permalink
  • Jharper

    Hi Adam

     

    I tried following what you said below, and on my new machine I received.

     

    1. I first installed a fresh copy of PDQ inventory.,(same version from my last machine)
    2. I copied over the whole admin arsenal folder.
    3. I copied over reg key from old machine, and dragged and dropped the PDQ inventory REG key export into to the “new” regkey folder
    4. I copied and pasted the Databse.db file and the “scans” folder as well as the “integration” folder into c:\programdata\Admin Arsenal\ PDQ inventory
    5. I copied and pasted the database.db-shm & Database.db-wal

     

    Am I doing something wrong?

    0
    Comment actions Permalink
  • Adam Ruth

    Try deleting the database.db-shm & Database.db-wal files on the new computer.  They're temporary files that will get re-created when needed.  It's usually okay to copy them between computers but we have seen this happen from time to time when they get copied and they don't match up exactly with the Database.db file.  

    0
    Comment actions Permalink
  • Jharper

    Tried deleting those 2 files... System wont let me because it thinks they are "in use by another program"..

    So i next deleted the reg key, and uninstalled the program....

    I re installed the  program and when to launch it , I got a message saying "you've uncovered a bug" and then the application crashed.

    Do you know what seems to be looking up those temp files from being deleted?

    Would you be able to document an exact step by step safe practice way to move the application + database from one computer to another? 

     

    I would like to try moving the DB and successfully installing the PDQ inventory application again from scratch on this same new machine that i am working with. I would prefer not have to Re-OS

     

    Thanks 

    0
    Comment actions Permalink
  • Adam Ruth

    Make sure that the background service isn't running, as it's going to open the database and lock all 3 files.  Unfortunately, it doesn't look like it's smart enough to release its locks if it runs into a problem, we'll have to get that fixed.  Just do a "net stop pdqinventory" and you should be able to delete the files.

    I've created a ticket to get this process fully documented, it's something that gets asked occasionally but we don't yet have a central place with all of the steps and gotchas.  I'll point you to it when it's ready.

    Update:   The new documentation is now available here.

    0
    Comment actions Permalink

Article is closed for comments.