Within the Admin Guide, there is a section which details how to clear the MSMQ configuration directly within the EnterpriseVaultDirectory database

Article: 100001173
Last Published: 2018-03-05
Ratings: 0 0
Product(s): Enterprise Vault

Problem

Within the Admin Guide, there is a section which details how to clear the MSMQ configuration directly within the EnterpriseVaultDirectory database.

Solution

Procedure 8: Clearing the directory database entries

To clear the directory database entries

1. Run SQL Management Studio and connect to the SQL server hosting the EnterpriseVaultDirectory database.

2. Enter and run the following SQL command:
 
USE EnterpriseVaultDirectory
UPDATE StorageServiceEntry
SET StorageArchive = '', StorageRestore = '', StorageReplayIndex = '', StorageSpool = ''
UPDATE RetrievalTask
SET RetrievalSpoolQueue = ''
UPDATE ArchivingRetrievalTask
SET MessageQueue = ''
UPDATE RetrievalTask
SET MessageQueue = ''
UPDATE JournalTask
SET MessageQueue = ''
UPDATE PublicFolderTask
SET MessageQueue = ''


The above query will clear all the MSMQ entries for all EV servers in the database.  If however, there are multiple EV servers, only the entries for the EV servers being migrated need to be cleared.
The attached text file contains two SQL scripts that will clear the MSMQ entries for specified EV servers.

 


Was this content helpful?