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
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
Related Content
- 3 months ago
- 11 years ago
- 12 years ago