Database Backup

Automatic Database Backup

Log360 MSSP can automatically back up its database at regular intervals, as scheduled by you. Using this option, you can back up the built-in PostgreSQL DB or external PostgreSQL and MS SQL databases configured in the product.

Supported DB versions for auto backup

• PostgreSQL: Version 9.6 to 10.21
• MS SQL: Version 2008 and above

Prerequisite for backing up external PostgreSQL

1. In the machine where PostgreSQL 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 <product_home>/pgsql/lib and <product_home>/pgsql/bin folders respectively. <product_home> refers to the home directory of Log360 MSSP.
3. Restart the external PostgreSQL server.
4. Repeat the steps 1 to 3 from above whenever you update the PostgreSQL server.

Steps to schedule database backup

1. Navigate to Settings → General Settings → Database Settings → Database Backup.
2. click the edit icon. in the Actions column.



3. Select whether you want to schedule the backup daily, weekly, or monthly and at what time from the Backup Frequency drop-down.
4. Enter the Backup Storage Path.
• You can either choose a local folder or shared folder to store the backups.
• If the shared folder you’ve chosen needs permission to store the backups, then put a check against the Authentication Required box, and enter the necessary credentials.

Note 1: If the shared folder is located in a workgroup computer, then create a new domain account in AD. This new account should have the same username and password as that of a local account in the workgroup computer. Use the credentials of this new account for authentication.

Note 2: If the specified path is wrong or unreachable, the backup will be stored in the default backup folder (<Installation_Folder\Backup>).

5. Set a retention period for the backup files from the Maintain Backup Files drop-down.

6. Click Save.

Other settings

• To disable auto backup for Log360 MSSP, click the icon located in the Actions column of the auto backup configuration table.
• To get the status of the latest backup, click the icon.
• To edit the backup schedule for a particular component, click on the icon located in the action column of the component.
• Use the Backup Now option to initiate a backup instantly.
• Use the Recent Backups icon in the status column to view all available backups.

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

If you've installed a new version of MS SQL server and want to configure it in Log360 MSSP in place of the old MS SQL server, you can do so by using the backup you've taken using Log360 MSSP. Just note that, in addition to the backup you've taken using Log360 MSSP, 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 whether:

• The database server is running.
• There is sufficient space in the backup storage location.