Does backing up the database also backup preferences?

Rob Poling

February 15, 2017 18:06

I was wondering this since I can't find an answer...

Does backing up the database in Deploy and Inventory also backup the program preferences?

3 comments

Shane Corellian
February 15, 2017 18:29

Yes. The vast majority of Preferences are stored in the database so they would get backed up.

0
Permanently deleted user
February 15, 2017 18:35
Most of the settings in Preferences are stored in the database, but some things like Alerts are stored in the registry and therefore are not included in the backup. Also, most interface adjustments like column width are stored in the registry.
```
HKEY_CURRENT_USER\SOFTWARE\Admin Arsenal
```
If you want to explore for yourself you can use "C:\Program Files (x86)\Admin Arsenal\PDQ Inventory\sqlite3.exe" to explore the database at "C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db". Most of the items in Preferences are stored in the Settings table.
```
SELECT * FROM Settings;
```
0
Rob Poling
February 15, 2017 20:39

Awesome. Thanks, guys. Just wanted to make sure I wouldn't lose all my preferences if something went wrong and I needed to reinstall and restore the DB from backup.

0

Please sign in to leave a comment.

New post