tjarman Jun 5, 2008   1:51 PM GMT

Here is what happened... The deletion was unintentional, but not done by a user. A few people were in the database performing various activities. One being a very intensive processing function that does alot of comparing between documents to weed out duplicate entries and note various differences between them. This was involving probably close to 30-40k documents at the time of the last data loss. This happened twice. The first time we did a complete db restore since we lost all but 600 records and they jumped in and started work again. Then it happened again but we lost maybe 200,000 records instead of 700,000. There were no error messages the first time. It was discovered when they asked me a question and I went in to answer it, only to find all the data missing. The second time it happened, received messages. One was "Server error: Insufficient memory". The second message was something that started with "Database corrupt". The latter message seemed to resolve itself as I didn't do anything to gain access back to the database. Server support may have done something. Who knows. But the net result was massive data loss. I've been able to identify the differences between the various backup copies by using the unique id of the documents. I'm collecting them and copying them to the production database. I would rather retain the unique id of the document though. I'm doing this with scripts - no way I can do this manually! I'm not sure that the removing the deletion stubs would buy me anything as I don't know much about them. And since the docs were not marked for deletion by a user (or script for that matter), I don't know that they are still out there. So that raises another question - would removing the deletion stubs work for me? I think the database does not do soft deletions. I'd check, but I just lost my connectivity to my work's network. Any thoughts?

90 pointsBadges: