DELETE OLD UPK TOPIC VERSIONS

By hallgroupJuly 30, 20141 comment

Is it possible to delete old versions of a topic? If a document is checked out and back in several times during development, a separate copy of the topic is created in the database, which bloats the overall DB size. I’m using MS SQL Express, so I want to be able to control the size of the DB to the greatest extent possible since the size limit is 10GB. I was thinking I could export topics that have multiple unnecessary copies, then delete and purge them, and then re-import which would start them fresh again. Anyone know of a simpler way?

- Anonymous

1 comment on “DELETE OLD UPK TOPIC VERSIONS”

hallgroup July 30, 2014 Reply

I’m not aware of an easy way of doing this. Certainly there’s nothing on the Developer Client > Administrator side. iirc it has to be done via calls straight into the database. You _could_ export/delete/purge/import but you’d lose all the Document History. You should be OK as far as broken links go, as once a document is created, its 32-character Document ID stays with it forever, even if it is moved between libraries. For ease of use /repeatability though I’d look at a DB query to select/delete old versions. You could maybe even set up a scheduled task to do it for you.

– Dirk Manuel

DELETE OLD UPK TOPIC VERSIONS

1 comment on “DELETE OLD UPK TOPIC VERSIONS”

Leave a Reply Cancel reply