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! |
Want to talk?
Drop us a line. We are here to answer your questions 24*7.