Forum Discussion

Slack's avatar
Slack
Level 4
7 years ago

Calculating space used - usage page - Single Instance etc.

Hi, We have a requirement to export ALL of our EV 11 Exchange Mailbox data out to PSTs (don't ask, has to happen), so we need to know how big this will be. I have the Vault Store Usage report. This...
Slack's avatar
Slack
Level 4
7 years ago

Hi Patrick

I have run that script as per below, it brings back data from each mailbox and their compressed and unompressed size.

The total of the uncompressed is not that different from the compressed size.

How does this take in to account single instrance storage?

If the below script gives me an uncompressed total - is that how much space I need to export everything? From previous posts, I fear not.

 

SELECT A.ArchiveName "Archive Name",
       SUM(S.ItemSize)/1024 "Compressed Size (MB)",
       SUM(SP.OriginalSize)/1024/1024 "Uncompressed Size (MB)"
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.Root R,
       EVVSYourVaultStore_1.dbo.ArchivePoint AP,
       EVVSYourVaultStore_1.dbo.Saveset S,
       EVVSYourVaultStore_1.dbo.SavesetProperty SP
WHERE  A.RootIdentity = R.RootIdentity
  AND  R.VaultEntryId = AP.ArchivePointId
  AND  AP.ArchivePointIdentity = S.ArchivePointIdentity
  AND  S.SavesetIdentity = SP.SavesetIdentity
GROUP BY A.ArchiveName
ORDER BY A.ArchiveName