Restore database and certificate registry key and credential store

To restore database and certificate registry key from the old server to new server:

  1. Create a new folder called ManagementServer in the following location: %ALLUSERSPROFILE%\Sophos\
  2. Copy the Backup folder from the old server to the ManagementServer folder on the new server that has been created.
    The folder path should be ...\Sophos\ManagementServer\Backup
  3. Open a command prompt at the DataBackUpRestore folder location: %ALLUSERSPROFILE%\Sophos\ManagementServer\Backup\DataBackUpRestore\
  4. Type the following command to restore the database.

    DataBackupRestore -Action=Restore -DataSourceType=Database

    Confirm by pressing y

    Note Ensure the Restore database successfully processed message is displayed. If it is displayed along with a Failed to restore message, go to the location (for example, depending on your SQL Server version): %ProgramFiles%\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Backup\ and check if the files are accessible (readable) with the SQL Server service account you are using. If the files are not accessible, provide read access to the SQL Server service account and re-run the command.
  5. Enter the following command to restore the credential store:

    DataBackupRestore -Action=Restore -DataSourceType=CredentialStore -password=[the password given earlier]

    Confirm by pressing y

    Note Ensure the Build succeeded message is displayed along with the Successful operations on credential store.
  6. Go to the Backup folder.

    %ALLUSERSPROFILE%\Sophos\ManagementServer\Backup

  7. Right-click the registry file CertificationManager.reg, select Merge and confirm.
    Note If you are migrating between 32-bit and 64-bit computers, you must edit the registry key.

You have finished restoring the database, credential store and certificate registry key.