Disappearing data again
Posted by mholmes on 04 Feb 2011 in Activity log
The same thing that happened at the beginning of last year, which I blogged here, has happened again. All data in the doc_to_docTypes_id field was set to null between August 16 and August 17 last year. I've restored it using the INSERT statements in the preceding backup, processed using Transformer 3 in my Win7 VM, using a sequence that builds UPDATE statements. However, I still have no idea how this could possibly be happening. I need to take a close look at the db itself. Googling reveals nothing....