Active Backup for Microsoft 365 or Google Workspace Portal is a valuable tool for safeguarding your data. However, when you look for backup data in Synology Active Backup, you might encounter errors. One such example is “An error occurred with the database.” This can be frustrating and potentially disruptive. In this very post, we will help you learn about the potential causes of this issue and assist you with the steps to resolve it effectively.
Possible Causes for Active Backup Database Error
Before heading to the troubleshooting steps, it’s essential to identify the possible causes of the error message. By knowing the causes, you can easily get to the effective solution. Common reasons for encountering this error include:
Database Connectivity Issues
The error may occur due to a loss of connection between the Active Backup application and the database.
Database Corruption
Corruption within the database itself can lead to errors during backup operations.
Insufficient Permissions
Inadequate permissions assigned to the Active Backup application or its associated database can result in this error.
How to Fix Database Error in Synology Active Backup?
The moment you’ve pinpointed the probable cause of the issue, you can proceed with the following troubleshooting steps.
Do This First
This error appears on Synology NAS when HDD migration or reset mode 2 is done. The database of Active Backup for Microsoft 365/Google Workspace has to be rebuilt. Follow the steps highlighted below to get the issue resolved.
- Go to Active Backup for Microsoft 365 or Active Backup for Google Workspace.
- Navigate to Task List and delete the task that caused search problems in the recovery portal.
- Select Create to launch Task Creation Wizard.
- Choose Relink an existing backup task.
- Click Next.
- Choose the task you just deleted to relink.
- The relinked task will display on the Task List.
- Run the task.
- As soon as the task is complete, launch Active Backup for Microsoft 365 Portal or Active Backup for Google Workspace Portal to check if its backup data is searchable.
If you still struggle with the same error, then execute the troubleshooting steps given below:
1. Check Connectivity
Confirm that the network connection between the Synology Active Backup application and the database server is stable. Verify that the database server is running and can be accessed from the machine where you have the Active Backup installed. You need to access Synology login page to verify the same. If using cloud-based databases, confirm that there are no connectivity issues with the cloud service provider.
2. Database Integrity Check
Perform a database integrity check to identify and repair any corruption issues within the database. Utilize database management tools or commands specific to your database platform to execute this check.
3. Review Permissions
Review the permissions assigned to the Synology Active Backup application’s database user. Ensure that the user has adequate permissions to perform backup and restore operations. Log in to get this verified.
4. Restart Synology NAS and Database Server
Restart both the Synology Active Backup application as well as the database server to reset any temporary configurations or connections. Monitor the system logs during the restart process to identify any potential errors or warnings.
5. Update Software
Ensure that both the Active Backup application i.e. the Synology NAS and the Microsoft 365 or Google Workspace database software are updated to the latest versions. Software updates often include bug fixes and improvements that can resolve compatibility issues leading to errors.
Conclusion
Encountering errors such as “An error occurred with the database” in Active Backup for Microsoft 365/Google Workspace Portal can disrupt your data management processes. By following the troubleshooting steps outlined in this article, you can effectively identify and resolve the underlying issues, ensuring the smooth operation of your backup system. Remember to maintain regular backups of your data to mitigate the impact of any unforeseen errors or failures.
