Scheduling database backups and cleanups for the KiwiVision Manager role - KiwiVision 4.8.0 | Security Center 5.12.0.0

KiwiVision™ User Guide for Security Center 5.12.0.0

Product
KiwiVision
Content type
Guides > User guides
Version
4.8
Release
4.8.0
Language
English
Last updated
2024-07-17

It is important to protect your data by scheduling regular database backups. Also, regularly clean your database to remove old data so that the database does not grow beyond its capacity. If the database is full, your integration might stop working.

Before you begin

Ensure you have the following privileges:
  • View role properties
  • Modify role properties
  • Administration > Plugins

What you should know

  • The KiwiVision™ Manager database stores events with images and metadata, load balancing data related to the hardware used for the KiwiVision Analyzer roles, and the state of the analytics.
  • The default SQL Express database server has a size limit of 10 GB, which might be exceeded when storing many events with images. When the limit is exceeded, no new events can be saved in the database.
  • It is a best practice to schedule all database maintenance during non-peak hours.

Procedure

  1. From the Config Tool homepage, open the Plugins task.
  2. Select the KiwiVision Manager plugin role from the entity browser and click the Resources tab.
  3. Click Cleanup (), choose how long to keep events and when to delete old data, and then click OK.
    Database cleanup window showing data retention policy set for 90 days and cleaning scheduled for Sundays at 2:00 am.
    NOTE: By default, the For (keep data) setting is set to 90 days and the Clean each setting is set to Custom and no cleanup day is specified. Select the days on which the cleanup should take place. Otherwise, the cleanup will not run.
    Database cleanup window showing data retention policy set for 30 days and cleaning scheduled for every day at 11:00 pm.
  4. Click Backup/Restore (), choose the location for backup files, enable automatic backups at least once per week, and then click OK.
    For more information, see Backing up databases on a schedule.
  5. Click Apply.