How do I Backup UpdateEXPERT Premium 7.x?

Note: This article's parent is MSDE/SQL Datastore (7.x)

Backing up UpdateEXPERT Premium requires adequate free disk space to backup product directories, patch remediation database files, and MSDE database files. This can require several hundred megabytes of space.

This article assumes you are backing up and restoring on the same machine, without host-name changes and using the same product build.  Keep a copy of your UpdateEXPERT Premium serial number for re-installation.

This article has 3 sections, as follows:

Backing Up UpdateEXPERT Premium 7.x
Restoring UpdateEXPERT Premium 7.x
Backup/Restore Sample Scripts

Backing Up UpdateEXPERT Premium 7.x

Important: This procedure does not include backup/restore of the settings management (SecurityEXPERT) directories. This is because these directories are re-created when UpdateEXPERT is re-installed, and consist of web interface pages (ASP pages) used for settings management. If you wish to add these directories to your procedure, add the following:

C:\Inetpub\wwwroot\SBSCorporateClientWS
C:\Inetpub\wwwroot\SecurityEXPERT
C:\Inetpub\wwwroot\SEServerWS

Stop Services

1. > net stop ueagent

2. > net stop mssql$sbsdb

Copy Directories & Files:

3. C:\Program Files\St Bernard Software\UpdateEXPERT\*

4. C:\Program Files\Common Files\UpdateEXPERT\*

5. %SYSTEMROOT%\UEAgent\*

6. %SYSTEMROOT%\System32\Codec4ue3db.dll

Run AgentUtil (Leaf-Agent and Agent Settings Data):

7. Use C:\Program Files\St Bernard Software\UpdateEXPERT\AgentInstaller\AgentUtil.exe (as explained in this AgentUtil article) to backup Leaf-Agent and Agent Settings information from the Registry.

Export these Registry Keys:

8. HKEY_LOCAL_MACHINE/Software/St. Bernard Software/UpdateEXPERT

9. HKEY_LOCAL_MACHINE/Software/St. Bernard Software/UEJobs

10. HKEY_LOCAL_MACHINE/Software/St. Bernard Software/SecurityEXPERT

11. HKEY_CURRENT_USER/Software/St. Bernard Software/UpdateEXPERT

Copy MSSQL$SBSDB Database Files:

12. C:\Program Files\Microsoft Sql Server\MSSQL$SBSDB\Data\UEDataStore.mdf

13. C:\Program Files\Microsoft Sql Server\MSSQL$SBSDB\Data\UEDataStore_log.ldf

14. C:\Program Files\Microsoft Sql Server\MSSQL$SBSDB\Data\SEDataStore.mdf

15. C:\Program Files\Microsoft Sql Server\MSSQL$SBSDB\Data\SEDataStore.ldf

Restoring UpdateEXPERT Premium 7.x

Re-install UpdateEXPERT:

• If desired, completely uninstall UpdateEXPERT Premium, then re-install.

• Launch UpdateEXPERT Premium 7.x to make sure it is functioning.

Stop Services

1. > net stop ueagent

2. > net stop mssql$sbsdb

Restore Directories & Files:

3. Overwrite directories with your backup files.

4. Copy the Codec4ue3db.dll file to the System32 directory, overwriting the existing file.

Restore Registry Keys and Leaf-Agent Data:

5. Restore registry and AgentUtil data.

Restore Database Files:

6. Replace the UEDataStore and SEDataStore database files with the backup UEDataStore and SEDataStore database files.

Start and Launch:

7. > net start ueagent (this will start mssql$sbsdb automatically).

8. Launch the Console.

Backup/Restore Example Scripts

Note: These samples provided primarily to identify the components requiring backup/restore.  Be sure to modify and test them in a manner appropriate to your environment!