1. Perform a backup of the EnterpriseVaultDirectory database.
2. Stop Enterprise Vault services.
3. Open SQL Query Analyzer.
4 To gather the ComputerEntryID run the following query and replace EV1 with the Enterprise Vault server name that is experiencing the problem . The server name will be displayed in the Enterprise Vault Administration Console below Enterprise Vault servers.
USE EnterpriseVaultDirectory
SELECT ComputerEntryID
FROM ComputerEntry where ComputerName = 'EV1'
5. Run the following query to determine the values before running the next query. Replace 'the value from step 4' with the value that is returned is step 4.
USE EnterpriseVaultDirectory
SELECT StorageArchive, StorageRestore
FROM StorageServiceEntry
WHERE ComputerEntryID = ''
6. Run the following query to clear the values for the StorageArchive and StorageRestore message queue. Replace 'the value from step 4' with the value that is returned is step 4.
Note: Ensure there are no spaces in between the single quotes in the SET line.
USE EnterpriseVaultDirectory
UPDATE StorageServiceEntry
SET StorageArchive = '', StorageRestore = ''
WHERE ComputerEntryID = ''
7. Start the Enterprise Vault services.
8. Open Computer Management, expand Message Queuing, expand Private Queues and verify enterprise vault storage restore and enterprise vault storage archive queues are created.