Moving Enterprise Vault data to highly-available locations

In outline, the procedure for moving the data to highly-available locations is as follows:

IndexRootPathEntry [IndexRootPath]

  • Move the contents of this location to a highly available location.

  • Update the database using SQL to point at the new location.

The SQL to view the current location is as follows:

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>')

PartitionEntry [AccountName]

  • Move the pool entry authorization (.pea) file to a highly available location.

  • Use the Vault Administration Console to view the properties of the EMC Centera partition and then, on the Connection tab, edit the Pool Entry Authorization File Location box to point at the new location.

PartitionEntry [PartitionRootPath]

  • Move the contents of this location to a highly available location.

  • Update the database using SQL to point at the new location.

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

The SQL to update the location is as follows:

UPDATE PartitionEntry
SET PartitionRootPath = '<THE NEW
LOCATION>'
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

PartitionEntry/Locations [SecondaryLocation]

  • Move the secondary storage files to a highly available location.

  • Update the database using SQL to point at the new location.

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
INNER JOIN Locations ON
PartitionEntry.SecondaryLocation =
Locations.LocationIdentity
WHERE (PartitionEntry.PartitionEntryId ='<ID FROM LOG FILE>')

The SQL to update the location is as follows:

UPDATE Locations
SET Location = '<NEW LOCATION>'
WHERE LocationIdentity =
(SELECT SecondaryLocation FROM PartitionEntry
WHERE PartitionEntryId = '<ID FROM LOG
FILE>')

PartitionEntry [StagingRootPath]

  • Move the contents of this location to a highly available location.

  • Update the database using SQL to point at the new location.

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

The SQL to update the location is as follows:

UPDATE PartitionEntry
SET StagingRootPath = '<THE NEW LOCATION>'
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

PSTMigratorTask [MigrationDirectory]

  1. Move the contents of the location to a highly available location.

  2. Use the Vault Administration Console to view the properties of the PST Migrator Task and update the Temporary files folder.

ShoppingServiceEntry [ShoppingRootPath]

  • Move the contents of this location to a highly available location.

  • Use the Vault Administration Console to edit the Shopping service location to the new highly available location.

SiteEntry [PSTHoldingDirectory]

  • Move the contents of the location to a highly available location.

  • Use the Vault Administration Console to view the site properties and update the PST Holding Folder property to point at the new location.