Determine Site / Site Collection Size (SharePoint 2007 & 2010)

1.   Open SharePoint 2010 Management Shell / Windows Command Prompt with Runas Administrator

2.   Enter below command to access "stsadm.exe" and press enter

cd "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN"

(Replace 14 by 12 for SharePoint 2007)

3.   Type below command and press enter

STSADM.exe -o enumsites -url "<Url of the web application>"

4.   Command will give text output where you can see site/site collection details like:

a.   Url

b.   Ower

c.   Content Database

d.   Storage Used MB

e.   Storage Warning MB

5.   Modify the command with text file path to get output in text file

Example:

STSADM.exe -o enumsites -url "<Url of the web application>" > c:\SiteDetails.txt

Contact Me for any technical help related with SharePoint 2010.