Scheduling database backups and cleanups for the Digital Signage Management plugin - Security Center Digital Signage Management 2.3

Security Center Digital Signage Management Plugin Guide 2.3
Applies to
Security Center Digital Signage Management 2.3
Last updated
2023-05-26
Content type
Guides > Plugin and extension guides
Language
English
Product
Security Center Digital Signage Management
Version
2.3

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 Directory database stores the plugin configuration and related entity types.
  • The plugin role database stores the events and the entity configuration.
  • The plugin role database contains plugin properties, related entities, events, and alarms associated with variable message signs.
  • 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 Digital Signage Management 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 you 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.