Manually restoring an EngageOne Designer repository using SQL Management Studio

Operating system: Windows
Versions affected: 5.x 6.x
The Repository Configuration Tool is provided with the software to enable the user to restore a repository backup of an EngageOne® Designer repository, but if the user is unwilling or unable to use this utility, a repository backup can be manually restored using the SQL Management Studio and any utility that can extract the content of a zip file (for example WinZip, WinRar, 7-Zip).

The following steps should be followed:

1. Open SQL Management Studio and connect to the relevant SQL instance
User-added image

2. Once connected to the SQL instance, select the Databases folder, right click and select Restore Database

User-added image

3. This brings up the add database dialog, where the Device radio button should be selected   The browse button invokes an additional dialog to browse to the database backup file required, the default is a .bak file, but if "all files" is selected for the view, the .dbk file will be seen in the browser.  Note that the backup file must be on a local drive, this browser does not access mapped network drives:

User-added image

4. Once the backup file has been selected, the setting that were in place for that database at the time the backup was taken will show in the files section of the menu.  In here, the destination for the row data and the log file can be modified to a location on the machine where the database is being restored.  This can be done by selecting the Relocate all files to folder check box, and browsing to the desired location, or by editing the path in the Restore to column:

User-added image

5. Once this is done, in the General section ensure the Restore check box is active, and hit OK.  This provides a status in percentage terms, and once the restore is complete a pop up will appear informing the user that the restore is complete.
6. The filestore backup zip needs to be extracted to the required location on a local drive.
7. In the database, open the Tables and browse to the dbo.Global table, right click and select Edit top 200 rows, this will return the following view:

User-added image
Explanation of relevant parameters:
FileStoreRoot = where the contents of the filestore backup zip have been extracted.
BackupRoot = where repository backup .dbk or .bak files will be deployed when a backup is taken.
ZipRoot = where repository backup filestore zip files will be deployed when a backup is taken.
Build = version of EngageOne Designer that was in use when the backup was taken.

Note:  When restoring a database, it can only be restored in the same version or a later version of SQL Server that was in use when the backup was taken.
UPDATED:  December 7, 2018