Database restore fails with "Error during database restore. Please check the Control Center log file for details."

Products

• Messaging Gateway

Issue/Introduction

Restore of the Control Center database has failed and information regarding the failure has been written to the Control Center log file BrightmailLog.log

Viewing the Control Center log

1. Go to Status > Logs
2. Select the following filters
   Component: Control Center
   Log type: Console Logs
3. Download the BrightmailLog.log file
4. Open the BrightmailLog.log file using any text editor

Cause

There are a number of potential reasons the database restore might have failed:

• The backup file has been modified
  Aug 11 2025 09:55:30 [Thread-15] [ScriptHelper] ERROR - Cannot restore the database from the remote host. 
Aug 11 2025 09:55:30 [Thread-15] [ScriptHelper] ERROR - ERROR: Backup signature verification failed.
  
  
• Incorrect credentials when transferring the file from an FTP or SCP server
  Aug 11 2025 09:16:09 [Thread-15] [ScriptHelper] ERROR - Cannot restore the database from the remote host. 
Aug 11 2025 09:16:09 [Thread-15] [ScriptHelper] ERROR - Failed to transmit the file: Error: Bad password [ [email protected]'s ]ERROR: Unable to retrieve archive from the specified URL.

Resolution

The backup file has been modified or fails signature verification

To ensure the integrity of the backup / restore process, Messaging Gateway backup files contain an internal cryptographic signature used to ensure that the backup file has not been modified. Any modifications or corruption of the backup file will cause the file to be rejected by the Control Center to ensure data integrity and security. A corrupted or modified backup file cannot be restored to the SMG Control Center by any means and a different backup file will need to be selected for restore.

Bad username or password when downloading the backup file

Ensure that the credentials provided for the transfer / download of the backup file are correct.