Enterprise Vault Expired Mail Items Curiosity
Our site properties base expiry on Modified Date.
Our site retention policy is 7 years
If i view a users archive through archive explorer, the oldest item in the vault is from march 2009 (we archive after 15 days), so all seems well.
However in the archive the oldest item date is shown as 2006 (see below):
I also ran the sql query
USE EnterpriseVaultDirectory
SELECT ArchiveName, OldestItemDateUTC, YoungestItemDateUTC, HighestItemSequenceNumber, IndexedItems
FROM EnterpriseVaultDirectory.dbo.IndexView
ORDER BY OldestItemDateUTC
Which brought back a vast number of pre 2009 items, and a lot of NULL (which i think can be explained by them being the 32bit archive - Is that right ?)
Anway, can anyone explain the variance to me ?
Is it as simple as the index retains all information, even after expiring and purging items ? or is there more to it ?
Thanks