Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Measure Vault Store Partition sizes

Created: 14 Feb 2014 • Updated: 04 Apr 2014
Ben Shorehill's picture
0 0 Votes
Login to vote

Hi there,

It's often important to keep track of the size of your partitions. I've created a simple script that will report the size of each of your partitions. This script requires SQL Server 2008 R2 or greater on the server as well as SQL Server 2008 R2 Management Objects & Windows PowerShell Extensions for SQL Server on the machine running the script. There is a handy guide to this here.

This script runs remotely so it may take a while to run. However I have run this script on 11.5TB of data and it returned the result overnight.