SharePoint 2007 – find out the size of all site collections

The first step is to create a batch file containing:

SET STSADM=”c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\STSADM.EXE”

%STSADM% -o enumsites -url <Your Site> SiteStats.txt

Pause

Replace <Your Site> with the web application that you would like to find the sizes. For example http://myapp

Next you need to copy the batch file to your Web front-end server and run it.

The output will be in a file called SiteStats.txt. Open the file and for each site collection you will see ‘StorageUsedMB=’ and a value. It’s the value that you’re interested in.

Advertisements