Recovery procedure 5: Clearing the directory database entries

Article:HOWTO56543  |  Created: 2011-08-01  |  Updated: 2013-07-12  |  Article URL http://www.symantec.com/docs/HOWTO56543
Article Type
How To


Subject


Recovery procedure 5: Clearing the directory database entries

You can clear the directory database entries for all of the Enterprise Vault servers in your environment, or for selected servers.

The SQL query that is provided in this section clears the entries in the database for all the Enterprise Vault servers. If you have multiple Enterprise Vault servers in your environment, you may want to recover only some of the servers. The following technical note provides alternative SQL scripts that let you specify the servers for which you want to clear directory entries:

http://www.symantec.com/docs/TECH127004

To clear the directory database entries for all of the Enterprise Vault servers

  1. Run SQL Query Analyzer and connect to the server running the Enterprise Vault Directory service.

  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 = ''

See About using EVSVR as part of the recovery procedure


Legacy ID



id-SF650183657_v41328148


Article URL http://www.symantec.com/docs/HOWTO56543


Terms of use for this information are found in Legal Notices