Indy,
Your suggestions are very good! We can't tell why some files and not others are gone.
We don't have another system or disks to easily move the production DB off to.
We have a Raid environment. I will check to see if the Raid disks failed or got corrupted. In the heat of the battle I didn't think of that, I am only thinking of triage and surgery. (I am a tech guy but I thought I would throw in some medical terms I remember from 'Mash'). Thanks for this!!
I have backups, just not full ones that include the Import Items. We were able to identify and find 1204 files. I am running 'recuva' in low priority mode right now to find some more of the corrupted files.
I have added backing up the ImportItems to the future backup but that doesn't help us now.
Tonight we are going to backup the AC database to another disk. Then we will restore the backup made before the crash. That will give us a report of the still missing files, if any.
Your suggestions have been spot on! Thank you for responding to James. I find your message very helpful.
John
