Logging the Rebuild and Repairs

Both the rebuild and the repair processes are logged automatically in the filesys.log file. This file is stored in the Windows directory of the workstation PC or on the server if you are running in client server mode. It is appended with all file systems warnings errors and events. When ever you perform a rebuild or a repair EXACT will log it in this file. For a single file rebuild the entry would look similar to the following,

Rebuild Started

**4/7/2000 11:04:08 :

Rebuilding SFEE

Record count before rebuild: 523

Record count after rebuild: 523

**4/7/2000 11:04:08 :

Rebuild Finished

If you think there have been any problems with the rebuild or repair then you should check here first as any abnormalities will have been noted in addition.

Where should I run Rebuilds and Repairs?

Rebuild and repairs should be run on the server. This is mainly because the process will run a lot faster with the data being accessed locally than if it has to travel across the network. It also cuts out any possibility of network errors affecting the process.

If you are running in client server mode, the rebuild and repair processes will automatically run on the server even if they are started on the workstation. You will notice that the bars that keep track of the process are a lot lumpier than if it is started directly on the server, as they are not updated so often.

See also...

About Rebuilding Indexes

Re-indexing & Repairing EXACT Data

About Repairing Tables

Next >>

Delete Aged Data