locked
Sharepoint 2007 - AllDocVersions - Purge items marked for deletion RRS feed

  • Question

  • I have a program which uses the SP api to delete all versions from the AllDocVersions table (my test site).  I need to know what timedjob will clean these items out of the table (flagged with marked for deletion).  I do not want to delete from the db directly.  I have size considerations to think about (80gb will be deleted) so I really need to know the process from start to finish.  I've researched the net and have hit a brick wall when it comes to doing this the right way.  Thanks for all resonses.
    Thursday, November 3, 2011 1:44 PM

Answers

All replies

  • Any thoughts folks?  Checked my db this morning and I show all of my items marked for deletion in the recycle bin and the AllDocVersions table.  That definitely won't work in the production environment.
    Friday, November 4, 2011 12:41 PM
  • I'm assuming there isn't a clean way to do this given the amount of replies I've received (0).  Does anyone have anything to add?
    Monday, November 7, 2011 1:06 PM
  • Hi chootduck,

    SharePoint 2007 default timer jobs don’t provide a timer job to clear the AllDocVersions table, the column DeleteTransactionId in the table stores a hexadecimal value that shows whether the rows is needed or currently active within SharePoint environment. When the column value contains anything else than the 0x, the row is marked for deletion, however it is still here by default.

    In this situation, you may consider creating a custom timer job for it, for more information about custom timer jobs, please refer to:
    http://msdn.microsoft.com/en-us/library/cc406686(v=office.12).aspx

    More information, delete deleted items:
    http://collab.rdacorp.com/2008/08/mosssharepoint-2007-deleting-deleted.html
    SharePoint content database: AllDocVersions:
    http://www.hexanes.com/?p=846

    Thanks,
    Qiao

    • Marked as answer by chootduck Tuesday, November 8, 2011 1:13 PM
    Tuesday, November 8, 2011 6:52 AM
    Moderator
  • Thank you Qiao.  I feel better now, just wanted to confirm my suspicions and make sure I was clear.  Time to reclaim some space!
    Tuesday, November 8, 2011 1:12 PM