Keep your data safe by regularly backing up.
Backing up the Ape
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 or MS SQL
Server, or even if the database is kept on the same computer. Here
are a few suggestions . . .
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.
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
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:
- Use your own backup routine to backup 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.
- Use the following backup routine to safeguard
MS Access Backup Utility
Use the Ape software database backup utility to create backup copies of the
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.
A success message is displayed if the backup operation was 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.
- First, close all open screens.
- From within Ape software, click the Restore Database option (directly below
the Backup Database) option in the Utilities menu.
- Click [Browse] from within the Restore Database dialog to navigate and select the
backed up database ready to be restored.
- Click the [Restore] button. Pay attention to the warning dialogs.
- When finished, click the [Close] button on the Restore Database dialog.
If any data screens have been left open, refresh or close and reopen to see the restored
Last updated: 30 Dec 2016
Compatibility: Ape software versions 5.x and Higher