Quick Inventory of SharePoint Databases Quick Inventory of SharePoint Databases
Meet Bhimani

Meet Bhimani

March 15, 2013

All Post
Quick Inventory of SharePoint Databases 81
Share:

Inventory SharePoint Databases

Often I have to quickly analyze SharePoint databases; both Content DBs as well as the full set of existing databases. This could be to see which of the databases are still a part of the farm. Here’s how to quickly see which Content DBs are mounted in the Farm:

 

get-spcontentdatabase

For the more general set of all databases associated with the farm, it is nice to know the type of each database. Here’s a quick query to get that for you:

Get-SPDatabase | select name, type
 
Happy farming!

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to talk?

Drop us a line. We are here to answer your questions 24*7.