✖
 
 

Database Backup

M365 Manager Plus can automatically back up its database at regularly scheduled intervals as scheduled by admins and technicians. Using this option, you can back up the built-in PostgreSQL database or external PostgreSQL and MS SQL databases configured in the product.

Supported database versions:

Prerequisites

For External pgSQL

  1. In the machine where pgSQL is installed, go to <postgresql_installdir>/data and open the posgresql.conf file. Search for wal_level entry. Uncomment the entry and change its value to archive.
  2. Copy all the files in <postgresql_installdir>/lib and <postgresql_installdir>/bin folders, and paste them in <Installation_Folder>/pgsql/lib and <Installation_Folder>/pgsql/bin folders respectively. <Installation_Folder> refers to the home directory of M365 Manager Plus that you're configuring the auto backup scheduler.
  3. Restart the external pgSQL server.
  4. Repeat Steps 1 to 3 from above whenever you update the pgSQL server.

Steps to schedule a backup:

  1. Log in to M365 Manager Plus as an administrator.
  2. Go to the Settings tab.
  3. Navigate to Admin → General Settings → Database Backup.
  4. Select the frequency that you want the database to be backed up using the drop-down list named Backup Frequency.
    • The drop-down list allows you to select the frequency. You have three options to choose from: Daily, Weekly, and Monthly.
  5. In the Backup Storage Path field, specify the local or shared folder where you would like to store the backup file.
    • Check the Authentication Required option and provide the required credentials if the specified shared folder requires permissions to store the backups.
    • If the shared folder is located on a workgroup computer, then create a new domain account in AD. This new account should have the same username and password as a local account on the workgroup computer. Use the credentials of this new account for authentication.
    • If the specified path is wrong or unreachable, the backup will be stored in the default backup folder (<Installation_Folder>\Backup).
  6. Select the retention period for the backup file using the Retention Criteria drop-down list.
    • In the Retention Period field, select the number of days that the backups should be stored. Backups older than the specified age will be discarded. If you've set the retention period to be Last 30 Days, when the backup schedule runs on the 31st day, the backups taken on the first day will be discarded.
    • If you want to control retention based on the number of files, you can select the number of files, after which previous backed up files will be deleted one by one. For example: If you have set the retention period to be Last 30 Files, when the 31st backup file is created, the first backup file created will be discarded.
    • You can also configure M365 Manager Plus to store your backups forever, in which case backups will not be discarded.

      Note: Minimum retention period is 15 days.

  7. Once done, click Save to save the configurations.

    8. save the configurations

    Once a scheduler has been created, you can view the following information, and perform the following actions:

  8. You can view the time of the next scheduled backup, the location where the backup is stored, the last time the scheduler ran, and the status (success/failure) of the last backup. Refresh this set of information by clicking on Refresh icon. You can also run the backup operation manually by clicking on Backup Now.
  9. Click the Enable / Disable icon under the Actions column of the backup schedule to disable or enable the schedule.
  10. Click on the Edit icon under the Actions column to edit the backup schedule.
  11. Click the Backup icon icon to view the history of recent backups.
    12. Note:
    • If you use MS SQL, two backup files are created every time a backup operation is run. An .ezip file is created in the <Installation_Folder>\backup and a .bak file is created in the <MS SQL_directory>\backup. Both backup files are required to carry out any restoration. When you configure a retention period, only the .ezip file in <Installation_Folder>\backup will be deleted. The .bak files in the <MS SQL_directory>\backup will not be deleted. To delete the .bak files, set up a maintenance plan in Microsoft SQL Server management studio based on your retention period.
    • To view the steps on how to restore from a database backup file, click here.

Restoring backup from an old version of MS SQL server to a new MS SQL server

If you've installed a new version of MS SQL server and want to configure it in M365 Manager Plus in place of the old MS SQL server, you can do so by using the backup you've taken using M365 Manager Plus. Just note that, in addition to the backup you've taken using M365 Manager Plus, you need to copy the files in <MS_SQL_Old_Version>/Backup to <MS_SQL_New_Version>/backup.

Troubleshooting tips

If you get an error while backing up the database, please check if the following conditions are met:

Navigate to next Previous Topic Next Topic Navigate to next

Copyright © 2023, ZOHO Corp. All Rights Reserved.