Forum Discussion
Hi,
The size from Usage Report is not compressed. You may refer to the link below, there is a SQL query posted... you may use it to determined the actual size.
For export to PST, i would suggest at least prepare twice the size of storage for this.
regards,
patrickkuah
- VirgilDobos7 years agoModerator
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.
- Slack7 years agoLevel 4
Hi Virgil,
Same info as above. Gives a total size compressed and uncompressed - does this cater for Single Instance Storage?
Thanks - James
- patrickkuah7 years agoLevel 6
Hi,
Nope. thre query does not cater for single instancing. There is another EV report SIS ratio, you may use the ratio for your calculation though....
patrickkuah
- Slack7 years agoLevel 4
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
Related Content
- 3 months ago
- 11 years ago
- 12 years ago