We have some list items with workflows that went haywire causing those items to accumulate thousands of versions and take up too much space in the database. I should have set the list version limit from unlimited to a number and changed the items to truncate the versions but instead I deleted the items and then emptied them from the recycle bin and site collection recycle bin. The recycle bin cleanup job runs daily. I temporarily set it to run more frequently (minutes) but the content is still there. I can see the rows of the content still sitting in the alldocversions table albiet with a deletetransactionid assigned to it.
What is the mechanism to flush these delete items out of the content database? Thanks!
The renegade items total up a whopping 19 GB of unnecessary content so it will be definitely a good thing to get this cleaned up.