How to move the Index location to a different location on the same server
| Article:HOWTO59084 | | | Created: 2011-08-30 | | | Updated: 2011-11-15 | | | Article URL http://www.symantec.com/docs/HOWTO59084 |
Overview:
There may be an instance where indexes will need to be moved to a different location on the same server. This can be done for all volumes in a location or can be changed for just one archive.
Resolution:
Move all volumes in a root path to another existing root path on the same 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:
USE EnterpriseVaultDirectory
SELECT CE.ComputerName, 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
ORDER BY CE.ComputerName
Take note of both the IndexRootPathEntryIDs for the old index root path and the new index root path.
- Run the following query in SQL Query Analyzer 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 3b.
new IndexRootPathEntryId should be replaced with the IndexRootPathEntryId value returned for the new index root path in step 3b.
DECLARE @OrigIndexRootPathEntryId EVGUID
DECLARE @NewIndexRootPathEntryId EVGUID
SET @OrigIndexRootPathEntryId = 'old IndexRootPathEntyId'
SET @NewIndexRootPathEntryId = 'new IndexRootPathEntyId'
-- Check that we are moving on the same server
DECLARE @CurrentServer EVGUID
DECLARE @NewServer EVGUID
SELECT @CurrentServer = IndexServiceEntryId FROM IndexRootPathEntry WHERE IndexRootPathEntryId = @OrigIndexRootPathEntryId
SELECT @NewServer = IndexServiceEntryId FROM IndexRootPathEntry WHERE IndexRootPathEntryId = @NewIndexRootPathEntryId
IF (@CurrentServer <> @NewServer)
BEGIN
RAISERROR('You should only move indexing locations on the same server', 16, 1)
RETURN
END
-- 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 = (SELECT IndexServiceEntryId FROM IndexRootPathEntry WHERE
IndexRootPathEntryId = @NewIndexRootPathEntryId)
Move an entire root path to a new folder location on the same 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 index server to a new index location.
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.
- Run the following query in SQL Query Analyzer to update the index locations in the database
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)
Move all volumes for an archive
Use the Manage Indexes wizard in the Administration console to move all volumes for a particular archive.
|
|
Article URL http://www.symantec.com/docs/HOWTO59084
Terms of use for this information are found in Legal Notices
Thank you.