Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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.