• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Aug 302013

file321346127071 (Mobile)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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

  6 Responses to “Deleting an Enterprise Vault Archive”

  1. I have used below mentioned query to delete Journalin Archive (2TB approx)

    use EnterpriseVaultDirectory
    exec DeleteArchive ‘Vault ID’

    Can you please let me know how to reclaim space.


    • Hi Gautam,

      Thanks for the question.

      What space are you wanting to reclaim?

      Space on the file system? Vault Store Database space?


      • Hi Rob,

        Space on disk (file system)


        • If the archive has actually deleted (and not just marked for deletion)… Do you have sharing enabled within the Vault Store, or within the Vault Store Group? Do you have other Vault Stores in that same group, for mailbox archiving perhaps? If so then the items are likely shared between them, and will still exist on disk, until they’re gone from user archives.

          • it was actually a journaling archive (2TB). and not showing in marked for deletion as well in admin console. I am amazed to see whole 2TB gone in couple of seconds which ideally should take some time, I have used below mentioned query to delete it, but do not see space getting increased in disk :

            use EnterpriseVaultDirectory
            exec DeleteArchive ‘Vault ID’

            No sharing enabled within vault store.

            Any suggestion would be very helpful as how I can claim this 2TB space on disk.

            Perhaps, Some SQL query to reclaim.


  2. I can still see more than 10550199 save sets using your SQL query and they are not decreasing :

    Select count(*)
    From view_saveset_archive_vault
    Where ArchivePointID =

Leave a Reply to Gautam Cancel reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>