How to Move a Vault Store Partition or Vault Store

Article:TECH35742  |  Created: 2004-01-25  |  Updated: 2013-04-01  |  Article URL http://www.symantec.com/docs/TECH35742
Article Type
Technical Solution

Product(s)

Problem



This article describes how to move a vault store partition or vault store on the same Enterprise Vault server from one location to another.

Watch a video on this process


Solution



This process consists of four steps:

Step 1 - Confirm all achived items have been backed up (SQL Server)
Step 2 - Set backup mode, stop services, and copy vault stores or vault store partition to new location (Enterprise Vault Server)
Step 3 - Update the Vault Store location in SQL (SQL Server)
Step 4 - Start services, confirm archived items can be opened, and clear backup mode (Enterprise Vault Server)
 
Note: It is recommended to run a full backup on the EV SQL databases and vault store partitions before proceeding.

Step 1 – Confirm all archived items have been backed up (SQL Server)
  1. Open SQL Server Enterprise Manager (SQL 2000) or SQL Server Management Studio (SQL 2005)
     
  2. Run the following query: 
USE [Vault Store Database Name]
SELECT COUNT(*)
FROM WatchFile 
  1. If the count is 0, proceed to step 2. If the count is greater than 0, there are items left waiting either backup or indexing. For Enterprise Vault versions 9.0 (Base) and below refer to TECH68204 to update the item location, for versions 9.0.1 and above the Itemname field is a relative path and does not need to be updated.

 
Step 2 – Set backup mode, stop services, and copy vault stores or vault store partition to new location (Enterprise Vault Server)
 
A. Set Backup Mode
 
Set Backup Mode (Version 8.0 and higher) – Additional information refer to HOWTO57152
  1. In the left pane of the administration console, expand the Vault Store Group container.
  2. Right-click the vault store group whose vault stores you want to place in backup mode, and click Set State > Set Backup Mode on all Vault Stores
  3. Right-click the vault store group whose vault stores you want to place in backup mode, and click Set State > Set Backup Mode on all Index locations
Set Backup Mode (Versions 2007 7.5 and earlier) 
  1. Open the registry editor and navigate to:
[HKEY_LOCAL_MACHINE\SOFTWARE\KVS\Enterprise Vault\Storage]
EnableArchive
EnableCrawler
EnableExpiry
EnableFileWatch
EnablePSTMigrations
EnableReplayIndex
EnableRestore

If the keys do not exist, right click on the right pane and select NEW - DWORD

EnableArchive
EnableCrawler
EnableExpiry
EnableFileWatch
EnablePSTMigrations
EnableReplayIndex
EnableRestore
  1. Set the value of all the dword keys at decimal 0.
 
B. Stop all Enterprise Vault services
 
C. Copy the Vault Store data from the old location to the new location.
 
Step 3 – Update the Vault Store location in SQL (SQL Server)
 
To Move an entire Vault Store Group
  1. Open SQL Server Enterprise Manager (SQL 2000) or SQL Server Management Studio (SQL 2005)
  2. Run the following query and make note of the results.

USE EnterpriseVaultDirectory
SELECT VaultStoreEntryId
FROM VaultStoreEntry
WHERE VaultStoreName = '[Name of the Vault Store being moved]'

  1. Run the following query to update the PartionRootPath 
UPDATE PartitionEntry 
SET PartitionRootPath = '[File Path of the New Storage Location]'  
WHERE VaultStoreEntryId = '[Vault Store ID From Previous Query]'
 

 

To Move a single Vault store Partition or multiple Partitions

 

  1. Open SQL Server Enterprise Manager (SQL 2000) or SQL Server Management Studio (SQL 2005)
  2. Run the following query and make note of the results.

USE EnterpriseVaultDirectory
SELECT PartitionName, PartitionEntryId
FROM PartitionEntry

3. Run the following query to update the PartionRootPath 

UPDATE PartitionEntry 
SET PartitionRootPath = '[File Path of the New Storage Location]'  
WHERE PartitionEntryId = '[Partition Entry ID From Previous Query]'

Then repeat for each Partition as needed.

 If the location is a NAS device and not a local drive, simply update the PartitionRootPath to the new UNC path rather than using a local file path

 

Step 4 – Start services, confirm archived items can be opened, and clear backup mode (Enterprise Vault Server)

  1. Start all Enterprise Vault services
  2. Confirm archived items can be opened
  3. Clear backup mode
Clear Backup Mode (Version 8.0 and higher) – Additional information refer to HOWTO57152

a. In the left pane of the administration console, expand the Vault Store Group container.

b. Right-click the vault store group whose vault stores you want to clear backup mode, and click Set State > Clear Backup Mode on all Vault Stores

c. Right-click the vault store group whose vault stores you want to clear backup mode, and click Set State > Clear Backup Mode on all Index locations

 
Clear Backup Mode (Versions 2007 7.5 and earlier)
 
a. Open the registry editor and navigate to:

[HKEY_LOCAL_MACHINE\SOFTWARE\KVS\Enterprise Vault\Storage]

EnableArchive
EnableCrawler
EnableExpiry
EnableFileWatch
EnablePSTMigrations
EnableReplayIndex
EnableRestore
 
b. Set the value of all the dword keys at decimal 1.
c. Restart all Enterprise Vault services.
  

 




Legacy ID



273271


Article URL http://www.symantec.com/docs/TECH35742


Terms of use for this information are found in Legal Notices