Deleting older versions

vrapp · Post by **vrapp** » Wed Jan 12, 2005 11:49 am

Is there a way to keep only, say, 5 recent versions of every file in the database, and purge older versions?

I would like to reduce the size of the database; there are some large files in it with the history 40+ versions; I don't need that many. But I don't see how I could delete the older versions?

lbauer · Post by **lbauer** » Thu Jan 13, 2005 8:38 am

No, Vault doesn't have this function. But Vault only stores the latest version of a file, plus all the "deltas" or changes, so the database does not grow as much as it might if it stored every version.

You might be able to shrink the database down through some regular maintenance:

Configuring the settings below in the maintenance wizard should help:

Every day:

1- backup the transaction log

Every week:

1- Backup the entire database
2- UPDATE STATISTICS on all vault table indices

Every month:

1 - Check file structure consistency - DBCC CHECKALLOC
2 - Defrag the indices of all tables - DBCC INDEXDEFRAG

Every six months:

1 - Shrink the database DBCC SHRINKDB
2 - Rebuild all indices of all tables - DBCC DBREINDEX

vrapp · Post by **vrapp** » Thu Jan 13, 2005 9:23 am

lbauer wrote:No, Vault doesn't have this function.

could you please forward this as q request. I'm sure that after 2-3 years of usage, 99% of the users would appreciate it.

lbauer · Post by **lbauer** » Thu Jan 13, 2005 10:19 am

I'll log this to our features database. You're right, we've been asked about this before.