Back up data, credential store, registry and Secure Store

On the old server:

  1. Open a command prompt at the Sophos Enterprise Console installation directory.

    Windows version

    Default location

    32-bit

    C:\Program Files\Sophos\Enterprise Console

    64-bit

    C:\Program files (x86)\Sophos\Enterprise Console
  2. Enter the following command to back up the database:

    DataBackupRestore -Action=backup -password=[password to encrypt credentials]

    Note The password required for this command is used to encrypt the credential store backup. Make sure it's unique and sufficiently complex.

    A confirmation message is displayed and a Backup folder is created with a Database subfolder, registry keys, and Secure Store information in the following location:

    %ALLUSERSPROFILE%\Sophos\ManagementServer\

  3. In the Backup folder that has been created, create two new folders:
    • Router
    • DataBackupRestore
  4. Copy the table_router.txt file to the Router folder created earlier. The default location of the table_router.txt file is:

    %ALLUSERSPROFILE%\Sophos\Remote Management System\3\Router\table_router.txt

  5. Copy the Envelopes folder to the Router folder created earlier. The default location of the Envelopes folder is:

    %ALLUSERSPROFILE%\Sophos\Remote Management System\3\Router\Envelopes

    Note The Envelopes folder will be empty if you have no outstanding messages.
  6. Browse to the Sophos Enterprise Console installation directory.

    Windows version

    Default location

    32-bit

    C:\Program Files\Sophos\Enterprise Console

    64-bit

    C:\Program files (x86)\Sophos\Enterprise Console
  7. Copy the following files and folders to the DataBackupRestore folder created earlier.
    • Metadata (entire folder along with its contents)
    • DataBackupRestore.exe
    • DataBackupRestore.exe.config
    • ResetUserMappings.sql
    • TBK.bat
    • TRS.bat
    • Sophos.Credential.Store.Proxy.dll
    • Sophos.Management.AclUtil.dll
    • Sophos.Database.Configuration.Checker.dll

You have finished taking backup of data, registry, and Secure Store.