Scheduling database backups and cleanups for the Traka Asset Management plugin - TRAKA Asset Management 3.2

Traka Asset Management Plugin Guide 3.2.1

Applies to
TRAKA Asset Management 3.2
Last updated
2023-06-02
Content type
Guides > Plugin and extension guides
Language
English
Product
TRAKA Asset Management
Version
3.2

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

  • It is a best practice to schedule all database maintenance during non-peak hours.
  • The Directory database stores the plugin configuration and custom Traka entities.
  • The plugin role database stores:
    • Traka users
    • Traka events
    • Traka cabinets and iFobs
    • Settings on the Properties page
    • Relationship between the Security Center access rules and Traka groups

Procedure

  1. Open Server Admin and back up the Directory database.
  2. From the Config Tool home page, open the Plugins task.
  3. Select the Traka Asset Management plugin role from the entity browser and click the Resources tab.
  4. 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.
  5. 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.

  6. Click Apply.