Sage 100

Does anyone know what files with extension of .NWT and .NWF are used for? I can tell they are related to the extended files that are created when a table becomes larger than 2gb. I'm doing a rebuild of the IM_ItemTransactionHistory table in a test company and it took over 10 hours to rebuild and now I'm considering copying them back into the live company but I'm not sure if what the .NWT and .NWF files represent.

David both of those are created by Rebuild Key Files (RKF) as temporary files regardless of whether you're rebuilding multi-segmented files (when it exceeds 2 GB and a new segment 001 gets created then 002 etc) or a regular file. It happens at the beginning of Rebuild if I remember correctly. So you don't need to copy those over. But you do need to be certain RKF completed properly because normally those files are erased at the end. Having said that I wouldn't be surprised if RKF has a bug where it leaves the NWT and NWF unerased after rebuilding a segmented file. Hope that made sense.

yes it does make sense. they are still there because I'm waiting for the RKF to complete. it has been sitting ""comparing keys for...."" for over an hour. that explains why they are there. if it ever finishes they will probably be gone and I would have not needed to ask. but this is good information to know anyway. Thanks!

NWT (new table?) NWF (new file?)

Exactly Doug. That's what programmer Stu at Sage called them. He needed 2 temp files in addition to the OLD file he backed up as the original. New Table and New File is what they stand for.