Within the Admin Guide, there is a section which details how to clear the MSMQ configuration directly within the EnterpriseVaultDirectory database
Article ID: 100001173
Updated On:
Resolution
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:
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 = ''
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 Enterprise Vault (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.
Issue/Introduction
Within the Admin Guide, there is a section which details how to clear the MSMQ configuration directly within the EnterpriseVaultDirectory database.
Was this article helpful?
Yes
No
Powered by
