Return
-
Title
HOWTO: Remove redundant vault store partitions from EVnearSync -
Description
HOWTO: Remove redundant vault store partitions from EVnearSync -
Resolution
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:- 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
- Stop EVnearSync Services (EVnearSync Agent Services first; then EVnearSync Core Service)
- Execute removal in SQL (run the DELETE statement in SQL Management Studio) – examples of the removal scripts you can find below.
- 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 STATEMENTUSE 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 STATEMENTUSE 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 STATEMENTUSE 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 STATEMENTUSE 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