How to move the Index Location to a Different Location on a Different Server
| Article:HOWTO82325 | | | Created: 2012-11-15 | | | Updated: 2012-11-15 | | | Article URL http://www.symantec.com/docs/HOWTO82325 |
There may be an instance where indexes will need to be moved to an index location on a different index server. This can be done for all volumes in a location or can be changed for just one archive.
Resolution:
If working with Index Server Groups, the TARGET Index Server must be in the same Index Server Group as the SOURCE Index Server.
- Back up the SQL databases and the EV server.
- Stop all EV services on the server.
- Copy the contents of the index location from the old location to the new root path location. If a new index location is desired, it should be created before copying the indexes. This can be done on the "Index Locations" tab
To determine the index location, run the SQL query below:
FROM ComputerEntry CE, IndexingServiceEntry ISE, IndexRootPathEntry IRP
Take note of the IndexRootPathEntryIDs for the old index root path and the new index root path.
- Run the following query in SQL Server Management Studio to update the index locations in the database
Note:
old IndexRootPathEntryId should be replaced with the IndexRootPathEntryId value returned for the old index root path in step 3.
new IndexRootPathEntryId should be replaced with the IndexRootPathEntryId value returned for the new index root path in step 3.
DECLARE @NewIndexRootPathEntryId EVGUID
SET @OrigIndexRootPathEntryId = 'old IndexRootPathEntryId'
SET @NewIndexRootPathEntryId = 'new IndexRootPathEntryId'
-- Update the index volumes to point at the new location
UPDATE IndexVolume
SET IndexRootPathEntryId = @NewIndexRootPathEntryId
WHERE (IndexRootPathEntryId = @OrigIndexRootPathEntryId)
-- Inform EV that it needs to update the paths of the volumes on service startup
UPDATE IndexingServiceEntry
SET IVSyncNeeded = 2
WHERE ServiceEntryId IN (SELECT IndexServiceEntryId FROM IndexRootPathEntry WHERE
IndexRootPathEntryId IN(@OrigIndexRootPathEntryId, @NewIndexRootPathEntryId))
- Following completion of the SQL script, restart all Enterprise Vault Services.
Note:
When the Indexing Services start up, they will synchronize their respective index volume metadata, depending on the number of index volumes associated with the index root path relocation, this may take some time. The progress can be monitored in the Event Log.
When the Indexing Services start up, they will synchronize their respective index volume metadata, depending on the number of index volumes associated with the index root path relocation, this may take some time. The progress can be monitored in the Event Log.
|
|
Related Articles
Article URL http://www.symantec.com/docs/HOWTO82325
Terms of use for this information are found in Legal Notices
Thank you.