Backup and Restore Database

Keep Data Safe by Regularly Backing Up

Backing up Calibration Control (our Calibration Management Software) database on a weekly or even daily basis is a foolproof way to keep from losing data by accidental deletion or network/computer malfunction.

There are several solutions to keeping data safe while using MS Access, MS SQL Server, or even if the database is kept on the same computer.

Multiple Physical Locations Rule

Always ensure that the backup location is a different physical hard [disk] drive (HDD) location from the original file(s).  The farther apart geographically those locations, the better.

Backup Options

When installing Ape software, the default location for the MS Access database file is on the same computer where the software is installed.  See the help topic on finding your database to find the specific location.  In this situation, if the HDD crashes then all data will be lost.  Therefore, a good plan is to store the backup data on a data storage device separate from the computer (e.g., external HDD and/or cloud service).

If using the SQL Server version of Ape software, the location of the database (an MDF file) is controlled by the SQL Server and is incrementally backed up to an LDF file.  Depending on the selected choices during installation or migration (from MS Access to MS SQL Server), the database could be on the same computer or it could be somewhere on one of the servers in the network.

Whether using Access or SQL Server, there are two primary backup options:

  1. Use your own backup routine to back up the database and other important files to a remote location.  The remote location is an external storage device (e.g., HDD or key) or a network location other than the current computer.
  2. Use the following backup routine to safeguard data.

MS Access Backup Utility

Use the Ape software database backup utility to create backup copies of the database.  Find the [Backup Database] and [Restore Database] icons in the Utilities tab of the ribbon menu.

To use, select a file name for the backup; something like a date code and 'calibration_backup' work well.  Next, select the location or file path to backup to and then click the [Backup] button.  Remember to choose an HDD location other than the HDD where the live database is stored.

Backup Database

A success message is displayed if the backup operation was successful.

Backup Database Successful

Restoring a Database

Warning:  Restoring a database completely overwrites the current data.  Make a dated backup of the current database contents before restoring a previous version of the database.

  1. First, close all open screens.
  2. From within Ape software, click the Restore Database option in the Utilities tab.
  3. Click [Browse] from within the Restore Database dialog to navigate and select the backed up database ready to be restored.
  4. Click the [Restore] button.  Pay attention to the warning dialogs.
  5. When finished, click the [Close] button on the Restore Database dialog.

Restore Database

If any data screens have been left open, refresh or close and reopen to see the restored data.

Last Updated: 11 March 2019