Orphaned Doc Versions
Recently one of our content db blew up in size multiplying by 2.5 fold. Looking into the issue we found the AllDocVersions table to be expanding and we narrowed it down to a few lists that were running an out of control custom workflow. Well, while investigating the AllDocVersions Table, we also ran some queries looking for orphaned versions: SELECT * FROM AllDocVersions ADV LEFT OUTER JOIN RecycleBin AS RB ON ADV.DeleteTransactionId = RB.DeleteTransactionId WHERE RB.DeleteTransactionId IS NULL AND ADV.DeleteTransactionId <> 0x This statement generated thousands of records linking back to a few ID's that didn't match to any corresponding ID's in the AllDocs table. Does this mean we have a lot of orphaned versions that will never be deleted and don't link to any existing document(s)?
January 30th, 2011 4:04pm

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

Other recent topics Other recent topics