Issue
In some situations routing/export of data does not correctly have SQL entries in both the Item table, and the ItemEnterpriseVault table in the Archive Shuttle Item Databases.
Solution
The following SQL script will show all items in the Item table which do not have a corresponding entry in the ItemEnterpriseVault table:

SELECT * FROM Item
WHERE NOT exists(select 1 from ItemEnterpriseVault where Item.ItemId = ItemEnterpriseVault.ItemId)
Print Friendly, PDF & Email