Database Backup settings

You can specify that an OLAP database is automatically backed up, and the minimum interval between backups. The maximum interval is 7days.

You can back up the database manually at any time that an automatic backup is not in progress.

Note: When the system is under a high load, a backup might be queued and executed only after other operations are finished.

The backups are stored in the location that is specified on the Directories tab of the Farm Expert.

  1. Select Dashboards > OLAP > Save and Backup.
    The Database Backup widget shows the time at which the next backup is scheduled and the time elapsed since the last backup. The Last Backup field does not distinguish between manual and automatic backups.
  2. In the Databases widget, select the database to administer.
  3. In the Database Backup widget, select Backup Database Automatically.
  4. Select the appropriate time zone and specify this information:
    First Backup at
    Select the time at which the database is first backed up.
    Backup Interval
    Specify the number of days after the first backup, at which the database is next backed up automatically.
    Maximum Number of Backups
    Specify the number of automatic backups to save. The maximum number is 30.
  5. Click Save Settings.
  6. Optionally, to back up the database manually, click Backup Database Now and specify a name for the backup.
    You can specify the maximum number of manual backups to save. The maximum number is 30. The Backup Database Now button is disabled while you change the number of backups.