Admin – Database Backups

BOS databases can be set to back up automatically once a day, or users can manually back them up. There are also certain trigger actions that automatically create a backup (e.g. upgrading the database).

By default, the server is backed up daily, and the daily backups are kept for one week. In addition, QuickEasy backs up the databases once a week if a different frequency is not set.

Navigation: BOS Tools > Admin (BOS) > Right-click a subscriber > View / Edit Databases (context menu)

How to Set the Backup Frequency

1. Navigate to the Databases interface.
   • Note: If you are in the Databases interface, select a Subscriber from the dropdown list next to Databases.
2. Right-click a Database and select Set Backup Frequency from the context menu. 
   • Note: The default backup frequency is set to once a week for new databases.
3. Type the number of days between backups in the field next to Interval (days). Type zero to backup the database daily.
4. Click OK (button).

How to Manually Backup a Database

1. If you are in the Databases interface, select a Subscriber from the dropdown list next to Databases else right click a Subscriber and select View/Edit Databases from the context menu.
2. Click Edit (button).​
3. Right click a Database and select Backup from the context menu. 
4. Click OK (button).

How to Restore a Database from Backup​

1. Navigate to the Databases interface.
   • Note: If you are in the Databases interface, select a Subscriber from the dropdown list next to Databases.
2. Right click a Database and select Restore from the context menu. Fill in the popup as follows:
   1. Filter = Select a Subscriber from the dropdown list (default = selected Subscriber).
   2. Date = Select a period: All, Today, This Week, This Month.
   3. Type = Select one of the options from the dropdown list. The list indicates when or how the backup was made.
   4. Backup = Select the Database to restore from the list of available backups.
3. Click OK (button).

Technical Information

• Database backups are stored on the Backups/Database folder on AWS S3.
• The backup file is suffixed with the date to ensure files are not overwritten.
• After seven days a backup file is moved to Glacier storage and after 30 days the backup is deleted.
• Format: DatabaseName_keyword_verno_timestamp.