Law Enforcement Software
Law Enforcement Software
This Topic does not apply to the Enterprise Version of Crimestar RMS. The Enterprise Version of Crimestar RMS utilizes a much more robust and high performance SQL database and does not require this action to be performed.
Occasionally database indexes can become outdated or invalid as a result of a system crash, or potentially by accessing and updating a table from a program other than CrimeStar. When index files become outdated, you can update them by Reindexing them. CrimeStar will completely rebuild from scratch all database indexes based on their original definition.
While it is not likely that you will need to perform a Reindex, if you do, it is important that the process is done correctly to ensure the proper operation of the software. For this reason the entire Reindex process has been programmed into the CrimeStar.
Remember the Reindex process deletes the existing indexes and rebuilds them from scratch. This process may take a while to complete, and as always with database structural operations a backup should always be performed first.
What about a totally corrupted index file?
If an index file has become corrupted in such a way that Crimestar is unable to open the file, it may be necessary to physically delete the index file(s) from disk and completely recreate the file and rebuild the indexes. The good news is that index files don’t contain your user data, they only contain pointers to the data, so they can be completely without losing any of your data. To do this first make a backup copy of your database, then delete all the CRMSTRnn.CDX files (where nn is a number from 01 to 99). Important: ONLY delete the files with a .CDX extension as defined above. Deleting other files may result in a permanent lost of data. Then run the Validate.EXE program located in the Crimestar folder of your computer and choose the Reindex option. The validate program will create the CDX file(s) and rebuild the indexes in the files accordingly.
See: How to Reindex the Database