When Upgrading or Migrating the VIPRE Endpoint Security Console, it is recommended to ensure a copy of the Database is saved should any issues occur that may cause corruption.
Info
The type of Database being used (Internal / External) can be found by:
- Opening Site Properties
- Choosing the Advanced Settings tab
- Clicking Configure
Backup DB
Collecting the Console's SiteGUID:Each Database utilizes an identifying "SiteGUID" which needs to be saved.
- Open RegEdit and navigate to the following key:
-
Version 6.5 to Current:
- x86:HKLM \ Software \ VIPRE Business
- x64:HKLM \ Software \ Wow6432Node \ VIPRE Business
-
Version 5 to 6.2:
- x86:HKLM \ Software \ GFI Software \ VIPRE Business
- x64:HKLM \ Software \ Wow6432Node \ GFI Software \ VIPRE Business
-
Version 6.5 to Current:
- Note the "SiteGUID" to store with the backup of the Database
- Close the Console and stop the VIPRE Site Service
- Navigate to the "SQLite" folder in the Console's Volatile Data folder:
- C:\ProgramData\VIPRE Business\SQLite\
- Copy the Vipre.s3db file to a safe location with the SiteGUID
- Start the VIPRE Business Site Service
Backing up an External SQL Database:
If absent, install Microsoft's SQL Management Studio Express: 2005 / 2008
- Close the Console and stop the VIPRE Site Service
- Detach the VIPRE Database: How to Detach a Database
- Copy the Database's MDF and LDF files to a safe location with the SiteGUID
- Re-Attach the VIPRE Database: How to Attach a Database
- Start the VIPRE Business Site Service
Restore DB
Confirming the Console's SiteGUID:- Open RegEdit and navigate to the following key:
-
Version 6.5 to Current:
- x86: HKLM \ Software \ VIPRE Business
- x64: HKLM \ Software \ Wow6432Node \ VIPRE Business
-
Version 5 to 6.2:
- x86: HKLM \ Software \ GFI Software \ VIPRE Business
- x64: HKLM \ Software \ Wow6432Node \ GFI Software \ VIPRE Business
-
Version 6.5 to Current:
- Ensure "SiteGUID" is equal to the value saved with the Database
- If they are not, replace the entry listed in the Registry Editor
- Restart the VIPRE Business Site Service if the key was replaced
After this change, "Database Down" may be reported until restoration is complete
Restoring an Internal Database
- Close the Console and stop the VIPRE Site Service
- Navigate to the SQLite folder in Console's Data Repository:
- C:\ProgramData\VIPRE Business\SQLite\
- Replace the current VIPRE.s3db with the backup
- Start the VIPRE Site Service
Restoring an External SQL Database
If absent, install Microsoft's SQL Management Studio Express: 2005 / 2008
- Attach the Database Backup: How to Attach a Database
- Connect to this Database
- Navigate to the VIPRE Console's Site Manager to confirm success