Setting up the data backup

• General information on data backup

  Bp Event data backup protects your data from loss in the event of a malfunction, regardless of whether you are working with a Bp Event Standalone (single workstation) or a Bp Event Server installation.

  
  The data backup is configured once and then performed automatically at regular intervals. A logbook is written in addition to the data backup. It continuously records all database operations between two backup runs, thus ensuring complete data security.
  In case of a malfunction (e.g. power failure) that damages your database, it will be restored fully automatically. The last data backup is restored and the contents of the logbook are integrated. Within a very short time, you can put your application back into operation with the current data status.

  Important: The responsiblity for backing up your data lies with you. Please check regularly that the backup has been carried out correctly.

  
  Configuration of the Bp Event data backup
  Important: Save an additional copy of your backup files on a physically different medium (additional hard drive, USB stick, etc.) Otherwise the data backup could also be lost in the event of a hardware defect. Make sure there is sufficient storage capacity on that medium.

  Do not back up your data directly to the network drive, as there is a high risk of interrupted network connections. If you still want to save your backup files externally, first run the Bp Event backup locally and then copy this data to an external medium.

• Set up data backup for a standalone application

  Create a job for the automatic execution of the data backup (needs administrative permissions).

  1. Go to the  Configurations tab and select  Jobs >  New.
  2. Enter a unique Name and, if applicable, a Title for the job.
  3. Select "Data backup" as the job Type from the picklist.
  4. Select "Quitting the database" as the Start time/condition to start the data backup automatically when you log out of Bp Event.
     Note: If the standalone installation is restarted several times a day, it is advisable to set up the data backup daily at a fixed time (outside the Bp event usage).
  5. Enter the Target directory of the data backup.
  6. Enter the Number of backups.
     Note: 3 backup sets are set by default. The fourth backup automatically overwrites the oldest/first backup.
  7.  Activate the job in the toolbar of the input window.
  8.  Save your input by clicking on the icon in the top left-hand corner of the input window.
     Note: Every Bp Event user is informed of a faulty data backup. A red bar indicating the last successful data backup is displayed on login.

  Important: Make sure there is sufficient storage capacity on the target drive. The size of the database and therefore the required storage space can grow considerably over time. The minimum storage capacity can be calculated as follows:

  Required free storage space = (number of backups + 1)* size of data file

• Set up data backup for a server applocation

  Create a job for the automatic execution of the data backup. Make sure that the data backup is executed outside of the Bp event utilisation (server restart) and that no parallel jobs are set up (administrative permissions needed).

  1. Go to the  Configurations tab and select  Jobs >  New.
  2. Enter a unique Name and, if applicable, a Title for the job.
  3. Select a Service Client from the picklist.
     Note: As of version 12, it is possible to set up several service clients in the administrative settings and distribute the load of job processing to the various service clients. Jobs can be permanently assigned to a service client. Without a fixed assignment, the job is executed on a service client that has capacity at that time (load balancing). On a server with 32 GB memory and 8 cores, we recommend separating at least the web server and jobs on the service clients, and ideally also email retrieval on a separate service client.
     Example: Email retrieval separately on a service client, so other jobs and web users are not slowed down.
  4. Select "Data backup" as the job Type from the picklist.
  5. Select "Series" as the Start time/condition to start the data backup automatically as standard.
  6. Click on  Series to enter the start parameters.
     Recommendation: Set a daily data backup at a time outside the Bp event usage.
  7. Enter the Target directory of the data backup.
     Note: The target directory must be on the Bp Event Server.
  8. Enter the Number of backups.
     Note: 3 backup sets are set by default. The fourth backup automatically overwrites the oldest backup.
  9.  Activate the job in the toolbar of the input window.
  10.  Save your input by clicking on the icon in the top left-hand corner of the input window.
      Note: Every Bp Event user is informed of a faulty data backup. On login, a yellow bar is displayed, and after three days a red bar is displayed, indicating the last successful data backup.

  Important: The target directory on the Bp Event Server must also be accessible when the server is started as a service. The service is started under the local Windows user account System and may therefore not be able to access external drives. Ensure that there is sufficient storage capacity on the target drive. The size of the database and therefore the required storage space can grow considerably over time. The minimum storage capacity can be calculated as follows:

  Required free storage space = (number of backups + 1)* size of data file

• Set notifications for faulty data backups

  Bp Event users are automatically notified of a faulty data backup. A warning in a yellow bar will appear on the login screen and will change to red three days after the last successful data backup. A job can also be set up to notify one or more users by email.

  1. Go to the  Configurations tab and select  Jobs >  New.
  2. Enter a unique Name and, if applicable, a Title for the job.
  3. Select "Send email" as the type of job.
  4. Select "After error" as the Start time/condition to send the email if the data backup fails.
  5.  Link the Predecessor job to the data backup.
  6. Enter one or more email Recipients .
  7. Enter a unique Subject and a meaningful Text for the email.
  8.  Activate the job in the toolbar of the input window.
  9.  Save your input by clicking on the icon in the top left-hand corner of the input window.