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 in which i found below procedure:

SELECT *
FROM IndexRootPathEntry
WHERE (IndexRootPathEntryId = '<ID FROM
LOG FILE>')
The SQL to update the location is as follows:
UPDATE IndexRootPathEntry
SET IndexRootPath = '<THE NEW LOCATION>'
WHERE (IndexRootPathEntryId = '<ID FROM
LOG FILE>')

 

i want to know how can i use this comman, what is mean by "*" / where = ???? which log file is talking about, ca some one tell me the exact procedure and steps??

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')
  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    Level 6
    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

     

  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    Yes, the indexes need to be moved/copied to the new location before you update it.

  • mumair109917's avatar
    mumair109917
    Level 6
    13 years ago

    ok thnks alot once i finish i will mark solution. one more thing i need to know is i am planning to install EV failover node using microsoft cluster that is why i am moving all my data to shared storage. but i am little bit confissued about Shared Drive Letters because indexing drive is on first server is e:\ and the second server have the same drive as g:\. so what will be the behaviour what will be the location i have to use same folders for indexing on both servers so what will the good practise

  • AndrewB's avatar
    AndrewB
    Moderator
    13 years ago

    you have to have everything with the same drive letters or paths and as cluster resources.