What files can be reindexed?
Description
[BCB:1:Backup warning:ECB]

 

 NOTE: This is a reference table that shows which files can be reindexed. Refer to other articles for information as to how, why, and which files should be reindexed. Also note that the reindex file process is only an attempt to repair a damaged file. There’s never a guarantee that the process will work. 

  • The first column of the table is the actual file name located in your data folder
  • The second column is the name for that file as viewed in the Reindex File list
  • The third column is whether the file can be safely deleted without corrupting the rest of the database. If it can and you delete it, the information it contains will be lost, but it won’t corrupt the rest of your data

 

Files

Name in Reindex File List

Can safely delete

Address.dat

Addresses

No

AdvData.dat

Advisor User Data

Yes

AdvHist.dat

Advisor Message History

Yes

Alarm.dat

Alarms

Yes

Alert.dat

Alerts

Yes

Apiaccss.dat

Reindex with Repair Company only

Yes

Atmntbdl.dat

Attachment Bundle

Yes

Attchmnt.dat

Attachment

Yes

Audittr.dat

Audit Trail

Yes

Avgdtpay.dat

Reindex with Repair Company only

Yes

Bankrec.dat

Bank Rec

No

Bddetail.dat

Budget Details

No

BomHist.dat

BOM History

No

BomItems.dat

BOM Comps

No

Budget.dat

Budgets

No

Budgetar.dat

Budgets Ar

No

Cashflow.dat

Cash Flow

Yes

Cfacct.dat

Cash Flow Account

No

Cftrans.dat

Cash Flow Transaction

No

Chart.dat

Chart

No

Chartar.dat

Chart Ar

No

ChgOrder.dat

Change Orders

No

CODetail.dat

Change Order Details

No

Company.dat

Company

No

Connco.dat

Reindex with Repair Company only

Yes

Contacts.dat

Contacts

No

Cosess.dat

Reindex with Repair Company only

Yes

Cost.dat

Cost

No

Customer.dat

Customer

No

Defprfld.dat

Default Payroll Fields

No

EarnSumm.dat

Employee Earning Summary

No

Employee.dat

Employee

No

EmpPayinf.dat

Employee Payroll Info

No

Empprfld.dat

Employee Payroll Fields

No

Esprfld.dat

Employee Earning Summary - Fields

No

Eswage.dat

Employee Earning Summary - Wage

No

Eventlog.dat

Reindex with Repair Company only

Yes

Forecast.dat

Reindex with Repair Company only

Yes

Foredetl.dat

Reindex with Repair Company only

Yes

General.dat

General

No

GLCoat.dat

Reindex with Repair Company only

Yes

Grpdata.dat

Reindex with Repair Company only

Yes

Invchain.dat

Reindex with Repair Company only

No

Invcomp.dat

Reindex with Repair Company only

No

Invcost.dat

Inv Cost

No

Jobest.dat

Job Est

No

Jrnlhdr.dat

Jrnl Header

No

Jrnlrow.dat

Jrnl Rows

No

Jrnlsno.dat

Jrnl Serial No.’s

No

Lineitem.dat

Line Item

No

NotAdMsg.dat

Notification Additional Messages

No

NotCdVal.dat

Notification Conditional Values

No

NotMsg.dat

Notification Messages

No

NotRecip.dat

Notification Recipients

No

NotRecip.dat

Notification Recipients

No

NotRules.dat

Notification Rules

No

Notifica.dat

Notifications

No

Olacct.dat

Reindex with Repair Company only

No

Oltrans.dat

Reindex with Repair Company only

No

Paymethd.dat

Reindex with Repair Company only

No

PDSIDMap.dat

Sage HR ID Map

No

PEPUsage.dat

Reindex with Repair Company only

Yes

Periodar.dat

Period Ar

No

Permiss.dat

Reindex with Repair Company only

No

Phase.dat

Phase

No

Project.dat

Project

No

QtyDisc.dat

Qty Discount

No

RaiseHst.dat

Raise History

No

Recon.dat

Reindex with Repair Company only

No

Recpttag.dat

Recpt Tag

No

Recurex.dat

Recurring Transactions

No

Report.dat

Report

Yes

Review.dat

Employee Reviews

Yes

Roles.dat

Roles

No

Rptdata.dat

Report Data

Yes

Rptfilts.dat

Reindex with Repair Company only

Yes

Rstydef.dat

Reindex with Repair Company only

Yes

Rstyle.dat

Reindex with Repair Company only

Yes

Statcode.dat

Reindex with Repair Company only

Yes

Stathist.dat

Reindex with Repair Company only

Yes

Statnote.dat

Reindex with Repair Company only

Yes

Storetrx.dat

Reindex with Repair Company only

Yes

Stxhdr.dat

Reindex with Repair Company only

Yes

Stxrow.dat

Reindex with Repair Company only

Yes

Syspref.dat

Reindex with Repair Company only

No

Taxauth.dat

Sales Auth

No

Taxcode.dat

Sales Tax

No

Taxtable.dat

Tax Table

Yes

Template.dat

Template

Yes

Ticket.dat

Tickets

No

Unitmeas.dat

Unit/Measure

No

UPSinfo.dat

Reindex with Repair Company only

No

UPSship.dat

Reindex with Repair Company only

No

Userpref.dat

Reindex with Repair Company only

Yes

Userrole.dat

User Roles

No

Vendins.dat

Vendor Insurances

No

Vendor.dat

Vendor

No

Worktkt.dat

Work Tickets

No

 

Integrity Check Guide

Error: “The file cannot be reindexed. Only -1 out of a theoretical 0 records could be recovered. You must restore a complete, valid backup in order to continue using your company data."