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