Video Screencast Help
Archiving and eDiscovery Community Blog

Deleting an Enterprise Vault Archive

Created: 30 Aug 2013 • Updated: 29 May 2014 • 4 comments
Rob.Wilcox's picture
0 0 Votes
Login to vote
Have you ever wondered why an archive takes a long time to delete?  Sometimes you may be deleting a large archive and it seems to sit in the Vault Admin Console with the 'Marked for deletion' status and the little logo for a long time.  Well, it takes a long time because delete is a lot like archive in that there is a lot of different steps and processes that need to be gone through before the archive can be deleted.
 
Let's take an example.
 
Firstly we need to get the VaultEntryID for the archive we want to delete.  We can that with this bit of SQL:
 
Use EnterpriseVaultDirectory
Select ArchiveName, VaultEntryID, ArchiveStatus
From ArchiveView
Where ArchiveStatus = 4
 
That will show all the archives which are marked for deletion. If you know the archive name, then you could replace the 'Where ArchiveStatus = 4' with 'Where ArchiveName = 'Name of the Archive''.
 
Now you need to know which Vault Store the users archive lives on, you can find this out in the VAC quite easily, so I'll not cover that here.  Then you do the following bit of SQL to see how many items there are left to process (ie delete):
 
Use VSDbName
Select count(*)
From view_saveset_archive_vault
Where ArchivePointID = 'VaultEntryID from previous query'
 
This item-count will gradually gone down to zero.  Once it reaches zero, the archive will then be removed from the directory database.
 

Comments 4 CommentsJump to latest comment

karmakoma's picture

Thanks Rob, exactly what I was looking for!

I just want to confirm, if I delete an archive from the admin console, the last step is that it will delete the physical items from the vault stores, even if they are closed?

But a caveat is if there is a retention period of "forever" on that data it will not be deleted?

Thanks,

Darren.

0
Login to vote
Rob.Wilcox's picture

Yes the archive will be delete. I'm not sure about the keep forever retention category.. I think it will be ignored.  Further I'm not sure about archives that have legal hold items in them.

Perhaps you can test, and report back?

0
Login to vote
karmakoma's picture

Thanks Rob. I will have to test the retention category issue.

We don't use Enterprise Vault Compliance and discovery accelerator so no legal hold on items.

Cheers.

0
Login to vote
karmakoma's picture

According to KB article, retention category will be ignored http://www.symantec.com/business/support/index?page=content&id=TECH49804

Apart from legal holds or "of interest" items using Discovery accelerator, only if the checkbox for "Prevent deletion of archived items in this category" is checked for the applied retention category will this prevent deletion of an archive.

0
Login to vote