I am using Enterprise Vault version 8

• When testing File archiving I wrongly ticked the box in the retention category to prevent deletion of archived items in this folder.
• Befoer knowing this, I deleted the archived folders in EVA to undo my testing
• Now it is set as Marked for Deletion with a red cross by it but it is not getting deleted
• In the Enterprise Vault Event logs I periodically get the error Event id 7113 saying the following archive could not be deleted because it contains items that are on hold, or their retention category...
• My issue is that I tested quite heavily and so have all these vaults that will not get deleted until the retention period is up which is 7 years. I know this is correct behaviour but it doesn;t help my problem which was of course caused by me

I can think of two ways that may fix this. Can anyone help? Below are the ways I've logically thought of but don't know are possible:

1. I have the ArchiveID of the folders. Does anyone know the table in the SQL database that holds the rentetion period for a particular folder. My thinking is to script a change that would change this period to say 5 days?? Or if it calls a retention id then create a retnetion period of say 5 days and assign it to the problem folders?
2. Can I archive the same folders from test but change the rentention period? Or does the archive folder retain the rentention period when it was first set up?