Re: Table health check in 2000i? - 09-15-2005 , 10:11 PM
mzamborini (AT) gmail (DOT) com wrote:
You can use the BUTIL application provided with the database for a
simplistic data check. First, do a STAT command to find out how many
indices are in the file. Then, do a "BUTIL -RECOVER <filename> NUL" to
check the file physically, then for each index, run "BUTIL -SAVE
<filename> NUL N ##" where ## is each index number in turn.
Optionally, you can also run these options backwards (/J switch). Whew
-- lots of work.
Our free KeyCheck utility (available from
www.goldstarsoftware.com/download.asp) can provide this same
functionality in a simple command line "KEYCHECK <filename>". (Add /R
to scan in reverse order.) This saves a LOT of time and typing command
The freeware version is a DOS utility that has basic key checking
functionality. If you need something a little bit more robust, the
Win32 version of KeyCheck is also available for a small fee. This
version has improved error reporting (for scanning from batch files),
improved performance, and a special "QuickRead" function that only
reads a small subset of the data to improve performance during the scan.
You may also be able to find information on an ancient utility called
BSqueeze, sold by Mesa Business Solutions. These guys were bought out,
and the new company discontinued the product -- killing it off
completely. What a shame, since it was actually quite useful. Another
would be BtrDataSafe from Telistics -- haven;t heard much from them
recently, and there were some cases which this app didn't handle when I
looked at it last, but it may have been improved since then...
Let me know if you need anything more...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
BillBach (AT) goldstarsoftware (DOT) com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***