Backup Schedule

This section explains the database backup scheduling that can be performed in Applications Manager. Here you can perform instant database backup from Applications Manager and also schedule for database backup. The backup schedule settings comprises of 3 major configurations:

  • Backup Settings: Used for scheduling a backup of the database in Applications Manager. By default, database backup will be performed every month.
  • Cleanup Settings: Used to configure cleanup schedule, based on which old backup files and their logs will be removed.
  • Backup Execution: Used to perform backup execution instantly based on the type of data.

Scheduling backup and cleanup

To schedule database backup and cleanup, follow the steps given below:

  1. Schedule the backup by enabling/disabling under Scheduled Backup option.
  2. Choose the backup type. There are 3 types of backup:
    • Full Database: Takes complete database and CONFIG files as backup.
    • Config Data: All monitors configuration data alone taken as backup
    • Config & Reports Data: All monitors configuration data and report data taken as backup
  3. Configure the Time Settings for which the backup must be scheduled. You can choose from the following options:
    • Weekly: Choose a day in week to run backup schedule.
    • Monthly: Choose a date in month to run backup schedule.
  4. Configure the cleanup type based on which cleanup should be performed, under Cleanup based on option. You can choose from any of the 2 options:
    • Days: Cleanup based on number of days backup file is older.
    • Number of files: Cleanup based on maximum number of backup files to be kept.
  5. Click Save to schedule the backup and cleanup operations.

Also, you can view the list of backups that have already been scheduled by clicking the Last Backup icon on top right corner.

Backup Execution

You can also choose to perform instant database backup by configuring the Backup Execution settings. To do so, follow the steps given below.
  1. Choose the Backup Execution Type with which you want to execute the backup. You can choose from the following options:
    • Full Database: Takes complete database and CONFIG files as backup.
    • Config Data: All monitors configuration data alone taken as backup
    • Config & Reports Data: All monitors configuration data and report data taken as backup
    • Reports Data: Report data of all monitors
  2. Click Execute Now to perform the backup operation instantly.
Note:
  • Backup Execution is applicable only for PostgreSQL databases.
  • Database backup and cleanup will be performed only once in every month by default.
  • Full database backup alone can be performed for MySQL and MS SQL databases.
  • For MySQL databases, only backup and cleanup scheduling can be performed.
  • For MS SQL databases, backup scheduling alone can be performed.