Database Maintenance Overview |
Top Previous Next |
The database maintenance functions are miscellaneous functions you can use occasionally to check the database for anomalies or make manual corrections. Database anomalies like bad links, orphaned transactions, etc. could occur as a result of internal program errors, accidental deletion of records through Raw Data Tables or Pick lists, database corruption due to a computer crash, or improperly restoring from a backup database.
Except for the balance adjustment functions, it's a good idea to run through these every few weeks just to make sure no problems are occurring that need to be corrected. The "orphan" functions and the bad-links function can correct the database automatically. Unmatched transfers need to be manually corrected.
Most of these functions require administrator access (at least to make any changes), but the Orphan and Unmatched Transfer reports can be viewed with Manager access so they can at least be monitored more readily.
Networking note: Since some of these functions require a large number of records to be locked and modified, it's recommended that you perform these only on the Master workstation.
Topics:
Report and repair Orphaned Transactions
Report and repair Orphaned Reservations
Report Conflicting Reservations
Show the current database location
Move the database to Shared or Public Documents