This procedure is for use with ExpertALERT 2.7 or above. It covers identifying your database’s location and creating a backup.
Backing up an ExpertALERT database
This instruction is for NON-Replicating Databases only!
Backing up a database:
1. Determine the location of your database
Because the date/time stamp merely indicates the last time a database was opened and not necessarily the latest database, this is not a good indicator for your current source. Likewise, the database size is also not a good indicator of the most recent given the size is irrelevant. The easiest solution to determining your source is to launch your known database with ExpertALERT as you would normally.
Locate the SQL Icon in your System Tray.
Double click this icon to restore the window to full size.
Read through the entries. You should notice a line that states your database is being started.
Make a note of the path to this database.
NOTE: If you can launch your database and you do not have an SQL icon listed in your system tray, you are running a served database. This database needs to be shutdown on the server before it can be backed-up. Contact your IT department to perform a backup.
2. Creating a backup copy:
Open Window’s Explorer and navigate to the folder identified in step 1.
In this folder there should only be two files, a database and a log file. If you replicate your database, you should also find multiple log files. Do not create a backup of a replicating database.
If you find that you have more than this, you should re-organize your directories to keep the database separated from other files, especially other databases.
To create a backup, copy the entire FOLDER to your hard drive. This will ensure you capture the database and log file together. Remember, these two files should be considered a matched set.
Once you create the copy, rename the word "copy" to include the date and time. This will help keep your folder organized with the source and time of backup.
Note: Data Management is very tricky, and if you practice the routine of copying database, ensure you keep the folders labeled so you know which is current.
Saving backups on your local hard drive will not help if your computer crashes. Periodically these files should be transferred to a more secure location such as an external drive, network, or cloud.
To avoid risk, the best solution is Symphony Industrial AI's cloud service. Contact firstname.lastname@example.org for more information.