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:
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:
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
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy