Forum Discussion

mumair109917's avatar
mumair109917
Level 6
13 years ago

Move Indexing path of enterprise vault

Hi, we are using enterprise vault 9.0.1 for exchange 2010 with SQL 2008 R2, now i want to move my indexing data to shared storage which is currently on local drive. i have ev installation guide i...
Configuring
Enterprise Vault
Information Governance
Tip-How to
  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    13 years ago

    OK,

    On the EnterpriseVaultDirectory database run this:

     

    SELECT 
    IRPE.IndexRootPathEntryId AS 'Index Root Path ID',
    IRPE.IndexRootPath AS 'Path',
    CE.ComputerName AS 'EV Server'
    FROM 
    dbo.IndexRootPathEntry AS IRPE,
    dbo.IndexingServiceEntry AS ISE,
    dbo.ComputerEntry AS CE
    WHERE 
    IRPE.IndexServiceEntryId=ISE.ServiceEntryId AND
    ISE.ComputerEntryId=CE.ComputerEntryId
     

    That will list all your Index Root Path IDs, Path and EV Servers they belong to. Now run the following with the infor you recived from above:

    UPDATE IndexRootPathEntry
    SET IndexRootPath = 'NewLocation'
    WHERE (IndexRootPathEntryId = 'IndexRootPathEntryId')
     
    For example:
    UPDATE IndexRootPathEntry
    SET IndexRootPath = '\\server\new_index\location1'
    WHERE (IndexRootPathEntryId = 1158CE34B7F728248852B0F1297F0ACED1810000vltsrv01')
mumair109917's avatar
mumair109917
Level 6
13 years ago

where can i find IndexRootPathEntryId? or i have to copy and paste your command to to get results