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