User Tools

Site Tools


trimming_pervasive_extended_files_file._01

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
trimming_pervasive_extended_files_file._01 [2007/11/15 16:36 (17 years ago)] andrewtrimming_pervasive_extended_files_file._01 [2007/11/15 16:47 (17 years ago)] (current) andrew
Line 3: Line 3:
 This document assumes knowledge of using the **butil** command which is a part of Pervasive. This document assumes knowledge of using the **butil** command which is a part of Pervasive.
  
-When .BTR files become large, Pervasive will extend the database over multiple files. +When .BTR files become large, Pervasive will extend the database over multiple files. \\ 
 +Please review [[Pervasive Extended files (FILE.^01)]] for information on these extended files. 
 + 
 +There are rare times where the extended files will grow abnormally large.  If you have multiple extended Pervasive files for a specific .BTR record then it may be possible that these files are mostly empty space. 
 + 
 +**Process for rebuilding Extended files** 
 + 
 +  -  butil -recover file.btr file.rec  (copies the .BTR file to a database dump file) 
 +  -  copy file.rec file.rec.back (backup of the .rec) 
 +  -  delete file.btr (Restart system five and it will rebuild a blank database file.  The file can be copied out of the data53.zip) 
 +  -  butil -load file.rec file.btr 
 + 
 +\\ 
 +\\ 
 +\\ 
 +---- 
 +Author: arose\\ 
 +Editor: arose\\ 
 +Last Edited: 15-Nov-2007 
 + 
trimming_pervasive_extended_files_file._01.txt · Last modified: 2007/11/15 16:47 (17 years ago) by andrew