Issue
Sometimes there is a need to re-create a vault store partition in Enterprise Vault, I.E. re-create a partition without collection or due to space constraint move a partition to a different drive. EVnearSync doesn’t remove the old partition automatically, but you can see duplicates (both, old and new vault store partition) on these 2 pages in EVnearSync Web Interface:

  • Manage -> Failover -> Vault Store
  • Monitor -> General -> Consistency Checks

Solution
You can remove the references to the old partitions only in the SQL, EVnearSync Web Interface doesn’t support this.
NOTE: Decent level of SQL expertise is required here. Therefore; be careful please when executing the DELETE statements. If you are not familiar with SQL feel free to contact Customer Experience Team.
Please follow these steps if you want to remove redundant (old) partition from EVnearSync:

  1. Identify the partition what needs to be removed
    • This SQL query may help you with this task: SELECT * FROM [EVnearSync].[dbo].[EvPartitionEntry]
    • You need to get PartitionEntryId of the partition you want to remove from EVnearSync
  2. Stop EVnearSync Services (EVnearSync Agent Services first; then EVnearSync Core Service)
  3. Execute removal in SQL (run the DELETE statement in SQL Management Studio) – examples of the removal scripts you can find below.
  4. Start EVnearSync Services. (EVnearSync Core Service first; then EVnearSync Agent Services)

EXAMPLE 1

–Run the statements against to EVnearSync database
–Run the SELECT statement first please and make sure you get the expected results!
–You will get 4 records from the 2nd query (from MaintananceJobEntry table). This is ok because there are 2 consistency checks linked to 1 partition (and we are going to remove 2 partitions in this example).
–SELECT STATEMENT
USE EVnearSync
SELECT*FROM SyncJobEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')
SELECT*FROM MaintananceJobEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')
SELECT*FROM VaultStoreFailoverEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')
–DELETE STATEMENT
USE EVnearSync
DELETEFROM SyncJobEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')
DELETEFROM MaintananceJobEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')
DELETEFROM VaultStoreFailoverEntry 
WHERE PartitionEntryId IN('1A0F85E515633944693829284F4FB318E1q10000ev11-site','1A5E508965F78F64AB8BC11CC113B43401q10000ev11-site')

EXAMPLE 2

–Run the statements against to EVnearSync database
–Run the SELECT statement first please and make sure you get the expected results!
–All vault store partitions with SyncState=2 (in EvPartitionEntry table) are the partitions which do not exist in Enterprise Vault database anymore (EnterpriseVaultDirectory)
–SELECT STATEMENT
USE EVnearSync
SELECT * FROM SyncJobEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
SELECT * FROM MaintananceJobEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
SELECT * FROM VaultStoreFailoverEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
SELECT PartitionEntryId FROM EvPartitionEntry 
WHERE SyncState=2
–DELETE STATEMENT
USE EVnearSync
DELETE FROM SyncJobEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
DELETE FROM MaintananceJobEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
DELETE FROM VaultStoreFailoverEntry 
WHERE PartitionEntryId IN (SELECT PartitionEntryId FROM EvPartitionEntry WHERE SyncState=2)
DELETE FROM EvPartitionEntry 
WHERE SyncState=2
Print Friendly, PDF & Email