Navigation:  Database Management >

Database Manager

Print this Topic Previous pageReturn to chapter overviewNext page

Database management takes place from the Database Manager window. To access the Database Manager select File > Database Manager... from the Main Menu command bar.
 

Data Path

The location of the data files is set from here. Type the path in the box or browse for the location by clicking on the browse button. Typing in a data path that does not exist will create the location and a blank database. You can also change from snapshot data to live data by setting the data path.

Check Files

This command will check the files for errors and alert you if it finds any problems. In a multi-user environment, this command can only be used if there are no other users logged in.

Reindex and Pack Files

This command will reindex and pack the data files. The index files will occasionally become corrupted if a computer or server crashes while performing a database operation. Reindexing and packing the files will often correct the problem. In a multi-user environment, this command can only be used if there are no other users logged in.

Backup Files

The ADCAR Data Manager utility program includes built in backup functions which will copy the entire ADCAR database into a single compressed library file. (The backup library file is a standard PKZip™ format file.) The file can be directed to any local or mapped network drive accessible from the workstation. By default the backup files utility will use a date coded file name (i.e."ADCARyyyymmdd.ACB") when saving the backup. This allows you to easily identify the date on which a backup was performed. It is suggested that you save these date-coded backup files on removable media, and store them in a safe location.
 
If your data files are stored on a network server, they may be backed up on a regular basis as part of the server backup. Check with your network administrator to verify that the ADCAR data is being included in the server backups.

Restore From Backup

Use this procedure when one or more of the ADCAR data files is damaged and the rebuild operation failed, if one or more data files are inadvertently deleted, or you are moving the data files to a new directory or computer.

WARNING! The Restore From Backup function will wipe out ALL of the ADCAR data on your system, and replace it with the data on the Backup. Any changes or additions since the backup was created will be lost!

 

WARNING! Do NOT use the Restore From Backup function to Merge or Synchronize data between two machines!

 

Do NOT restore data to the same directory where any damaged data resides. Always restore to a new directory or delete all of the damaged data. Due to the complicated links between the individual data files which make up the ADCAR database, restoration of individual files is not allowed. You must restore all files, if you are going to restore any of them.

Restore Files Procedure

Be sure that ADCAR is not running on any other workstations.
Start the Data Manager
Specify a data path by typing the full destination data path into the Data Path field or by using the browse button.
Locate the backup media from which you want to restore.
Click Restore From Backup. If you are creating a new data directory, the Data Manager will confirm that you want to create the new directory. Click Yes.
Proceed past the "warning" dialog by clicking OK. The "Restore files from..." dialog will be displayed. Select the drive where your media is located in the Drives field.
Locate the backup file ("ACB" file) in the File list on the left, then select it by double-clicking on the file name. The restore process will begin.
When the restore is complete, the Data Manager will ask if you want to run the Check Files and Reindex & Pack functions. Respond yes to both.

ADS Server Selection

By default, when accessing files stored on a network server, ADCAR assumes that ADS remote server software is installed. If the network server is not running ADS remote server software, an error message will be generated and ADCAR will be unable to access the data files. Selecting "Force Local ADS" will cause ADCAR to use the local server with the networked data.

 

 


Page url: http://ISBAOSolutions.com/index.html?database_manager.htm