Scheduling database backups and cleanups for the Dynamic Log Book plugin - Dynamic Log Book 4.1

Dynamic Log Book Plugin Guide 4.1.0

Applies to
Dynamic Log Book 4.1
Last updated
2022-07-14
Content type
Guides > Plugin and extension guides
Language
English
Product
Dynamic Log Book
Version
4.1

To protect your data, it is important to schedule regular database backups. Also, to avoid growing beyond its capacity, you must regularly clean up your database to remove old data.

Before you begin

  • Ensure you have the following privileges:
    • Administrative privileges > System management > View role properties
    • Administrative privileges > System management > View role properties > Modify role properties
    • Task privileges > Administration > Plugins
  • Create a folder to store your backup configuration files. This folder is not created by default.

What you should know

  • The Directory database stores the plugin configuration and related entity types.
  • The plugin role database stores events.
  • It is a best practice to schedule all database maintenance during non-peak hours.
  • IMPORTANT: If the database is full, your integration might stop working.

Procedure

  1. From the Config Tool home page, open the Plugins task.
  2. Select the Dynamic Log Book plugin role from the entity browser.
  3. On the Resources tab, click Backup/Restore ().
    The Backup/Restore dialog box opens.
  4. In the Backup folder field, enter the filepath of the folder where you want to store your backup files.
  5. To reduce the size of backup files, turn on the Compress backup file option.
  6. To create backups on a schedule, do the following:
    1. Turn on the Enable automatic backup option.
    2. In the Every field, enter the day and time that you want to create a backup.
    3. In the Keep field, enter the number of backup files that you want to save.
    4. Click OK.
  7. Click Cleanup ().
    The Database cleanup dialog box opens.
  8. Configure the following:
    Keep data
    Select the frequency that you want to clean your database.
    Indefinitely
    Retains your data for an indefinite period of time.
    For specified number of days
    Retains your data for the selected number of days.
    Clean each
    Select the days when you want to clean your database and enter the time of day when you want to clean your database.
  9. Click OK.
  10. Click Apply.