Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a dedicated server running SQL server and many web servers running SharePoint 2010 installations. All the SharePoint web servers are using the same SQL server for storing/creating databases.

As I know, When SharePoint is installed it creates a collection of databases for itself to work (around 8 or 10).

Two Questions:

  • How can I know which group of databases belong to which installation of SharePoint?
  • When I uninstall SharePoint, the databases remain on the SQL server, how do I clean SQL from a removed/uninstalled SharePoint installation?


share|improve this question

Found a way to do it, using the PowerShell:

  • Go to Start => All Programs => Microsoft SharePoint 2010 Products => SharePoint 2010 Management Shell.
  • Type the Command: Get-SPDatabase

The list of DBs for the SharePoint installation will be shown to you.

share|improve this answer
As to your second question just delete the databases – Jim B Dec 18 '11 at 8:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.