Home > How-to Guides > How to backup and restore Messageware EPG database settings

How to backup and restore Messageware EPG database settings

This article applies to the following products:
Messageware Exchange Protocol Guard 2019

Messageware Exchange Protocol Guard 2016

Messageware Exchange Protocol Guard 2013

 

SUMMARY

 

The article provides a list of steps needed for backing up current configuration of EPG and restoring the configuration into a new database.

 

STEPS

To download the configuration from database, use the Config Uploader.

http://w3.messageware.com/download/support/Updates/Messageware_ConfigUploader/Messageware_ConfigUploader.zip

  1. Open the config Uploader
  2. Click “Select Folder” button to choose where the configuration will be stored
  3. Edit the Connection String in the application and replace the values as required.

Data Source – Sql Server Name

Initial Catalog – Name of EPG database

User ID – SQL account used for EPG database

Password – SQL password

 

 

Alternatively, in the catalog where Config Uploader is located, there is a file “connectionStrings.config”. Editing the connection string in that file will cause the Config Uploader to remember all the values above.

 

connectionStrings.config example content is shown below:

 

<connectionStrings>

    <add name="OGDatabaseConnectionString" connectionString="Data Source=DEMO_SERVER;Initial Catalog=YOUR_EPG_DB;User ID=USER_FOR_SQL;Password=SQL_PASSWORD"

        providerName="System.Data.SqlClient" />

</connectionStrings>

 

  1. When all the values are filled correctly, click the “Download” button. The configuration will be saved to the folder configured in step 2
  2. To upload the configuration to a new database, change the database name in the connection string and click “Upload”

 

Make sure that all values for connection string are matching on each Exchange Server in files listed below:

  C:\Program Files\Messageware\EPG\vDir\connectionStrings.config

 

  C:\Program Files\Messageware\EPG\Settings\connectionStrings.config

 

  C:\Program Files\Messageware\EPG\Settings\SWSettings.xml

 

  C:\Program Files\Microsoft\Exchange Server\V15\FrontEnd\HttpProxy\owa\auth\EPG\connectionStrings.config