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

This 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 "Send 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 the 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>

  4. When all the values are filled correctly, click the "Download" button. The configuration will be saved to the folder configured in step 2
  5. 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