Recovering list items
Hi, The scenario: SharePoint 2007, critical system which employs some workflow solution, suddenly all workflow tasks (which are 60 days old) have been deleted (as part of the clean-up job), now I'm tasked to recover all the lost data. All I have for the mission is the content DB backup file (.bak). As derived from the descriptions above, I probably should recover the data to some external DB and try to copy the deleted items to the real DB. My questions are: 1. Have you ever recovered single list items? Which DB table is relevant here? Any tips? 2. Have you ever recovered workflow data for list items? Any tips? Regards, Yoni Goldberg ...
September 12th, 2010 4:08pm

Hi, The list item data is stored under WSS_Content database and i used below query to access the list item. select tp_ID,nvarchar1 from AllUserData WHERE tp_IsCurrentVersion = CONVERT(bit, 1) AND tp_CalculatedVersion = 0 AND tp_DeleteTransactionId = 0 and tp_ListID in ( select tp_ID from AllLists where tp_DeleteTransactionId=0 and tp_title like 'List Title' and nvarchar1 like 'Item Title' ) hope it helps.My Blogs: http://www.sunilyadav.net Follow Me : http://www.twitter.com/yadavsunil
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2010 12:42pm

Hello, With the out-of-the-box backup/restore capabilities of SharePoint and SQL, you will not be able to perform a granular restore at the item or list/library level. There are third party tools that will do this, but not the native tools in SharePoint. You can try using the JQuery below, but another option would be to restore your backup from the content db to a new farm, reattach the content db, and then get your content out.Chris Caravajal MCTS SharePoint Help
September 13th, 2010 5:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics