Calculating space used - usage page - Single Instance etc.

Hi Titoine31

I don't believe this environment has ever had SSRS, unless this is part of the standard install of SQL Server. Which I don't think it is.

Upgrading is not an option, though that would certainly be a nice feature to have.

Hi mate,

Try this SQL query. It will give you both compressed and uncompressed (original) size of the data.

SELECT SUM(S.ItemSize)/1024 "Compressed Size (MB)",

SUM(SP.OriginalSize)/1024/1024 "Uncompressed Size (MB)"

FROM   VaultStoreDB.dbo.Saveset S, 

VaultStoreDB.dbo.SavesetProperty SP

WHERE  S.SavesetIdentity = SP.SavesetIdentity

 Just replace the VaultStoreDB with the Vault Store Database name.

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