07-04-2012 08:50 PM
I need to move index location to new location on same server. I found solution in KB (http://www.symantec.com/docs/HOWTO59084) but I have question about task to update the paths of the volumes on service startup. I can not set IVSyncNeed. And I can not found this column on table of IndexingServiceEntry. So my question if I don't run this task then my EV server can be work fine or not ?
Move an entire root path to a new folder location on the same server
To determine the index root path run the SQL query below:
USE EnterpriseVaultDirectory
SELECT CE.ComputerNameAlternate, IRP.IndexRootPathEntryID, IRP.IndexRootPath, ISE.ServiceEntryID, ISE.Description
FROM ComputerEntry CE, IndexingServiceEntry ISE, IndexRootPathEntry IRP
WHERE CE.ComputerEntryID = ISE.ComputerEntryID AND ISE.ServiceEntryID = IRP.IndexServiceEntryID
Take note of IndexRootPathEntryID for the index root path you are moving.
Note:
IndexRootPathEntryId to change should be replaced with the IndexRootPathEntryId value returned for the new index root path in step 3b. NewFolderPath should be replaced with the new location for the index location.
DECLARE @IndexRootPathEntryId EVGUID
SET @IndexRootPathEntryId = 'IndexRootPathEntyId to change'
-- Update the folder path
UPDATE IndexRootPathEntry
SET IndexRootPath = 'NewFolderPath'
WHERE (IndexRootPathEntryId = @IndexRootPathEntryId)
-- Inform EV that it needs to update the paths of the volumes on service startup
UPDATE IndexingServiceEntry
SET IVSyncNeeded = 2
WHERE ServiceEntryId = (SELECT IndexServiceEntryId FROM IndexRootPathEntry WHERE IndexRootPathEntryId = @IndexRootPathEntryId)
Solved! Go to Solution.
07-05-2012 06:14 PM
Just a different tool (SQL management studio in 2008 vs SQL enterprise manager in SQL 2000)
Launch SQL management studio > connect to your SQL server
Expand Databases > EnterpriseVaultDirectory > Tables > right click on dbo.IndexRootPathEntry and select 'edit top 200 rows'
Type the value of the new location into the correct row for IndexRootPath
Make sure you have the indexes in the new location first.
Remember that if you do this before you move the indexes, and accidentally start the indexing service, EV will automatically attempt to access indexes in that new location and, if they are absent, will attempt to rebuild them from scratch.
And at that point you cannot copy them over since the database will already reflect the fact the indexes are rebuilding.
Regards,
Jeff
07-04-2012 09:13 PM
that technote is specifically for EV10, which is why you dont have a IVSyncNeeded.
You can ignore that whole piece in your case as you have ev9 sp2.
07-05-2012 12:24 AM
you can use this Technote http://www.symantec.com/business/support/index?page=content&id=TECH35596 for Enterprise Vault 9.x
to move your index location.
07-05-2012 07:42 AM
My SQL version is 2008. I cannot found menu to change location. Do I must use sql query command and set it to new path?
07-05-2012 06:14 PM
Just a different tool (SQL management studio in 2008 vs SQL enterprise manager in SQL 2000)
Launch SQL management studio > connect to your SQL server
Expand Databases > EnterpriseVaultDirectory > Tables > right click on dbo.IndexRootPathEntry and select 'edit top 200 rows'
Type the value of the new location into the correct row for IndexRootPath
Make sure you have the indexes in the new location first.
Remember that if you do this before you move the indexes, and accidentally start the indexing service, EV will automatically attempt to access indexes in that new location and, if they are absent, will attempt to rebuild them from scratch.
And at that point you cannot copy them over since the database will already reflect the fact the indexes are rebuilding.
Regards,
Jeff