The "60 days clean-up syndrome", how to recover? RRS feed

  • Question

  • Hi,
    Like many others, I woke up just to find that SP job has deleted my WF tasks (and history) from a critical
    system... The tasks are being displayed in all the reports and are important to understand the flow of a process.
    Now we must recover the data somehow, we are mostly interested in recovering the WF instance and tasks.
    We have DB backups.

    I know we should deal with the Workflow table, from which table does the tasks items come? Any tips? Free tools
    to recover list items from DB backup?


    10x in advanced.

    Monday, August 30, 2010 9:18 AM


  • Hi Yonatann,


    The task items come from AllUserData table, it associate with workflow by tp_WorkflowInstanceId. there are some event handlers in EventReceivers table to trigger the relative workflow, the ContextCollectionId is workflow instance id.


    Best Regards,


    Friday, September 3, 2010 4:07 AM