Corrupt Btrieve files 1

[vbajock]

P-SQL 2000i SP3, ver 6.15 files. I have an order header file that somehow got corrupted and now shows no data. If you check it in DOS, it shows 13 megs in size. How do I go about trying to recover this file in PSQL 2000i? Did it ship with any utilities etc? I ran the file rebuild utility in Macola, and it came back with zero records.
Thanks

 

[mirtheil]

The rebuild utils should be available with the standard install of P.SQL. You can use BUTIL to rebuild a file. You would do something like:
1. backup the original file.
2. BUTIL -CLONE <newFileName> <originalFileName>
3. BUTIL -COPY <originalFileName> <newFileName>
4. Rename the original file to *.bak and then the new filename to the original filename.
Hope this helps.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[grnelson]

You can also take a look at BtSearch32 at

http://www.nssdd.com.

It has some file repair options like checking PAT pages and will also rebuild the file in a couple of different ways.



Gil

 

[vbajock]

This was almost a real bummer. We're talking the Open orders file. We had a backup, but we would have lost all the days orders, during the xmas rush. I called Pervasive Tech support first and they told me the file was a total loss. After I got done crying I ended up calling the guys at Goldstar software. I emailed the file to them and they emailed it back all fixed up. Those guys are freaking life savers. Bill Bach, if your out there in Tek-tips land, man I owe you one. I owe you guys too, because googling the stuff from your post lead me to them.