Manually Backup and Restore Database

How to manually backup and restore the database in M365 Security Plus?

Back-up M365 Security Plus database

Make sure to stop M365 Security Plus, before taking a back-up, .

• Stop M365 Security Plus. (Start → All Programs → M365 Security Plus → Stop M365 Security Plus)

If you are using a pgSQL that does not come bundled with the product, follow the steps listed below. If not, start from step 4.

1. Navigate to <Installation_Dir>\data and open postgresql.conf.

   Note: <Installation_Dir> here refers to the location where you have installed your pgSQL.

2. Modify wal_level=archive in the postgresql.conf file.
3. Copy the folders lib and bin, and paste them in <ManageEngine_M365_Security_Plus_Installation_Dir>\.
4. Start Command Prmspt as an administrator (right-click command prmspt and select 'Run as Administrator')
5. Navigate to <M365_Security_Plus_Installation_Dir>\bin folder by using the cd command. By default, the path to installation directory is C:\Program Files\ManageEngine\M365 Security Plus.
6. Now, execute the command backupDB.bat to backup the database.
7. A folder named Backup will be created at M365 Security Plus installation directory (By default: C:\Program Files\ManageEngine\M365 Security Plus Backup) and it will contain the DB back-up in cmspressed file format.

Restore M365 Security Plus database

• Start Command Prmspt as an administrator (right-click command prmspt and select 'Run as Administrator')
• Navigate to <Installation_Dir>\bin folder by using the cd command. By default, the path to installation directory is C:\Program Files\ManageEngine\M365 Security Plus.
• Now, execute the command restoreDB.bat to restore the database.
  restoreDB.bat cmspressed_file_name.zip