There are two schedulable backup tasks that run daily for BriefCam environments:
- PostgreSQL Database Backup
- Research Dashboards Backup
Two separate Windows Task Scheduler Jobs are created during installation with default times of midnight for the database backup task and 2 AM for the Research Dashboards backup task. The scheduled backup times can be changed in the Windows Task Scheduler.
PostgreSQL database backups
Restoring the PostgreSQL database from a backup requires a service outage by stopping the VS Server service for the deployment. It is highly recommended that administrators contact the BriefCam Support team before performing a database restore.
Depending on the circumstances leading up the need to restore a database, you may want to restore into an existing database or create a new database from a backup. The BriefCam Administrators Guide has script examples for both types of restoration.
Restoring database backups of research dashboards (Qlik)
Research data backups are written to a folder that is configurable after installation by editing the BI_Backup batch script and changing the value of the BACKUP_PATH parameter. It is recommended to set up a second backup task with a folder on another machine or copy the primary backups to a different machine for redundancy.
Restoring backups of the Research Dashboards uses the Research server installer to create a clean environment on a new server where the data from the previously failed server is transferred. The installer creates a fresh database when the install repository database service component is started. The administrator then uses a script to drop the fresh database, create a new database and restore the backed-up database from files. The full procedure is described in the BriefCam Administrators Guide documentation.