Difference: FileAnalysisAndRecovery (7 vs. 8)

Revision 82016-10-11 - JeffPrentice

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministration"

File Analysis and Recovery

Line: 35 to 35
 VERIFY KEY #2 - verifies the alt index #2, etcetera ...

QUIT - exit the "-an=" utility.

Changed:
<
<

FREELIST damage (APPX 4.0.a & earlier)

>
>

FREELIST damage (APPX 4.0.a & earlier)

  A type of file damage that VERIFY KEY #ALL does not tell you about is freelist damage. The freelist is the list of pointers in AppxIO files that point to deleted records. This list can get damaged. It could for example point to a live record, indicating erroneously that it is deleted.
Line: 57 to 57
 

Recovering a Damaged File:

Changed:
<
<
There are several techniques that can recover a damaged file. It's not possible to determine in advance which technique will give the best results, therefore we recommend you back up the damaged file, then try these techniques to see which one recovers the most data
Important Note
>
>
These techniques require thought knowledge of the Appx directory/file structure as well as the associated application files and processing. If you have any questions after reading these procedures, please call Appx Technical Support (1-800-879-2779) before proceeding.
 
Changed:
<
<
The Export and Import utilities should not be used for recovering a damaged file. The export routine will stop reading the corrupt file when the corruption is encountered. The resulting export file will be missing the remaining data records.

Rebuilding the key file

>
>
There are several techniques that may recover damaged file(s). We recommend that you back up your files before attempting one these techniques. Select the appropriate method after careful analysis of your particular situation.

Important Note

The Export and Import utilities should not be used for recovering a damaged file. In all likelihood this method will result in lost data.

Rebuilding the key file

  This is the easiest & simplest type of recovery. Either delete or rename the existing .key file, then run 'Create Files' on the Data File Management menu. This will rebuild the key file, and when it is complete run the 'Verify' step again to check the record counts and confirm the file is good. Even if the file passes verification, you might have lost data. If possible, check the file to see if any valid data was lost.
Changed:
<
<

Restoring files from Backup

>
>

Restoring files from Backup

  Note that all work performed since the backup was made will be lost.

When restoring design files, the entire application should be restored from backup, not just a single file. The best course of action is to restore all of the applications for the version to ensure that design integrity is maintained across applications.

Changed:
<
<
When restoring data files, it may be necessary to restore the entire database. For example, it makes no sense to restore an Order file without also restoring the line item file. Consider other files which may have been updated during the course of processing. Those files may also need to be restored.

APPX Recover Utility

>
>
When restoring data files, it may be necessary to restore the entire database. For example, it makes no sense to restore an Order file without also restoring its line item file. Consider other files which may have been updated during the course of processing. Those files may also need to be restored.

APPX Recover Utility

If the above techniques aren't successful, then you can run the Appx Recover Utility. This is the safest method for recovering your damaged or corrupt file(s).

 
Changed:
<
<
If the above techniques aren't successful, then you can try the 'appx.exe -r' option. You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.
>
>
You can also use this technique to recover accidentally deleted records, if you can perform this procedure in time. Since APPX re-uses deleted records, if new data is added after the deleted records, the deleted record may already be overwritten.
  Usage:
In Windows: %APPXPATH%\..\appx.exe -r old.file new.file [deleted.record.file]
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback