I'm sure you've come across this ...
One of our faculty members inadvertently deleted a large number of student responses to a discussion board this weekend and is looking to try to recover these responses.
Is there any way of recovering this data?
We restored a database backup taken the morning prior to the deletion. I was able to retrieve the raw post data with a query like http://iangoh99.blogspot.com/2011/04/find-out-which-messages-are-published.html
In this case, there were image attachments they wanted.
In some cases, the image src's pointed to external URLs. In other cases, we were seeing @X@EmbeddedFile.location@X@file_name_paths.