Defragmentation removes excess space from the database and can improve system performance
by reorganizing the database. The database becomes defragmented after long use because the system
adds and removes entries without placing them in the optimal position (much as a hard drive
becomes defragmented through use). The defragmentation-specific options include:
/f
Sets the filename for streaming data defragmentation. The default setting is
TEMPDFRG*.STM. Normally, you won??™t need to change this setting.
/i Prevents ESEnTUtl from defragmenting the streaming file.
364 CHAPTER 14 WORKING WITH DATA
/p Preserves the temporary database. Generally, ESEnTUtl deletes the temporary database
once all of the changes are incorporated into the main database.
/b Creates a backup copy of the database prior to defragmentation
using the specified filename. It??™s always a good idea to use this option so that you have another
copy of the database should the defragmentation fail.
Recovery helps you overcome database errors. ESEnTUtl rebuilds the database using log
entries. This is a typical feature of transactional databases where the database manager logs every
action.
Pages:
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861