Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks,

share|improve this question

1 Answer 1

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

 
discard

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.