Scheduling database backups and cleanups for the KiwiVision™ Manager role - KiwiVision™ 4.6.1 | Security Center 5.10.4.0

KiwiVision™ User Guide for Security Center 5.10.4.0

Applies to
KiwiVision™ 4.6.1 | Security Center 5.10.4.0
Last updated
2022-06-22
Content type
Guides > User guides
Language
English (United States)
Product
KiwiVision
Version
4.6

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 home page, 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 30 days and cleaning scheduled for every day at 11:00pm.
    NOTE: By default, the Keep data setting is set to 30 days and the Clean each setting is set to custom and has no clean up day specified. This means that data will never be cleaned up unless you select a day on which it will occur. Parking signs typically change messages frequently, which makes them likely to cause issues related to excessive data accumulation. If your organization has many parking signs, you should consider one of the following options:
    • Decrease the retention period for your data in the Database cleanup window
    • Upgrade your SQL subscription to accommodate more data and increase your local data storage capacity
    Database cleanup window showing data retention policy set for 25 days and cleaning scheduled for Sundays at 8:00pm.
  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.

  5. Click Apply.