This article explains how to use the DataBackupRestore.exe program to either backup or restore your Sophos management server's configuration. The DataBackupRestore.exe program is available with Sophos Enterprise Console 5.x and higher.
With this tool you can backup or restore the following components of your management server:
The instance name (local) is not a local SQL Server instance Build FAILED.
The instance name [RemoteServerAddressAndInstance] is not a local SQL Server instance Build FAILED.
Warning: Cannot find file C:\Program Files (x86)\Sophos\Update Manager\cac.pem
Known to apply to the following Sophos product(s) and version(s) Enterprise Console 5.3.1Enterprise Console 5.4.0Enterprise Console 5.4.1Enterprise Console 5.5.0
Note: The program should be run from a command prompt. If you have User Account Control (UAC) enabled and are not logged on as the Administrator account you will see the error: The requested operation requires elevation when attempting to run the program. Either:
The requested operation requires elevation
cd "C:\Program Files (x86)\Sophos\Enterprise Console\"
cd "C:\Program Files\Sophos\Enterprise Console\"
The available options are:
DataBackupRestore.exe [-Action=action] [-SubSystem=subsystem] [-DataSourceType=datasourcetype] [-DBInstance=dbinstance] [-ExcludeDB] [-S]
The table below shows some of the more common commands you may want to use.
DataBackupRestore.exe -action=backup -datasourcetype=database
DataBackupRestore.exe -action=backup -datasourcetype=all -ExcludeDB
DataBackupRestore.exe -action=restore -datasourcetype=database
DataBackupRestore.exe -action=restore -datasourcetype=all -ExcludeDB
For a practical example see the 'Enterprise Console 5.x server to server migration guide' in the documents section of the website.
Windows 7 or 2008+
Backing up or restoring the configuration files will fail if you have not installed the Enterprise Console to the default location. In order to use the DataBackupRestore.exe program the configuration files must be in the default program files locations:
For example if you installed the console to 'C:\NonDefault\Sophos\Enterprise Console\' and attempted to backup or restore the management server's configuration you will see several errors returned in the command prompt window:
Warning: Cannot find file C:\Program Files\Sophos\Enterprise Console\<THE_FILE_NAME>.config
Using the DataBackupRestore.exe program for non-default installation locations is not currently supported. We may look to support non-default installation locations in the future.
Note: These files are not a requirement of a full backup and should only be preserved if you have manually changed values under the guidance of Support.
Please note that the message is only a warning and will not affect the backup/restoring process. The warning occurs because the cac.pem file is located in a different folder when the installation has been upgraded from a previous version and not a fresh installation. We have provided the necessary steps below to workaround the warning.
<FileLocation inProgramFilesX86="true">Update Manager\cac.pem</Filelocation>
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.