0

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,

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
1
  • As to your second question just delete the databases Commented Dec 18, 2011 at 8:27

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.