Get Active Databases in SharePoint 2010 Farm


Follow these steps to list all active databases in the SharePoint 2010 Farm:

  • Logon to your SharePoint server farm (preferably the server that hosts Central Admin)
  • Click Start
  • Click All Programs
  • Click SharePoint 2010 Products
  • Click SharePoint 2010 Management Shell (run as administrator)
  • Type Get-SPDatabase | Select Name | Out-File c:\alldbs.txt (this will create the file for you if it doesn’t exist)

Published by Aryan Nava

Founder of "BlockchainMind", CTO for two Blockchain startup during 2018, Cloud/DevOps Consultant and Blockchain Trainer

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: