Open the Sharepoint management shell
Then
Run the following command
To get list of databases
Get-SPDatabase
The following command to get list of every database used and its Size
Get-SPDatabase | Sort-Object disksizerequired -desc | Format-Table Name, @{Label =”Size in MB”; Expression = {$_.disksizerequired/1024/1024}}
To know how much total space is needed
Run the following
Get-SPDatabase | ForEach-Object {$db=0} {$db +=$_.disksizerequired; $_.name + ” – ” + $_.disksizerequired/1024/1024} {Write-Host “`nTotal Storage (in MB) =” (“{0:n0}” -f ($db/1024/1024))}
Advertisements
Excellent, exactly what I was looking for.
LikeLike
thanks very much
send me at kazaki82@gmail.com
LikeLike
May I know how to find the database size in SharePoint 2007 farm? Also how to determine if the databases listed are pointing to the hostname or alias? Please help….
LikeLike
sorry for not replying i have just seen it do still have the problem
you can send me at kazaki82@gmail.com
LikeLike
This mignt be a stupid Question but dose this include the Sql log size or just the DB size
LikeLike
Database Size
since you are making backup to the database then the log is purged and has no size
LikeLike