SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. 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 noticed quite a few SharePoint content databases with random names (i.e. WSS_Content_30cb56f0b9eb430a8a2e3180604efd7b). I believe these were created by developers during deployment, and were never removed. I realize this may be a question I should ask a DBA: How do I determine whether these databases are being used?

share|improve this question
up vote 1 down vote accepted

If you would like to know what DB is used for a site collection you can go to the central administration, open aplication managment, then click on view all site collections. Select a site collection that you wish to check. There is information what DB is used for this site collection.

The reason why I told about site collection is site collection is the smallest piece that can store in the separated DB.

share|improve this answer
Thanks. I don't know which particular farm these databases could have been created from. We have at least three different SharePoint applications in multiple environments. That would be at least nine instances of SharePoint 3.0 Central Admin I need to go to. Is there a way of just checking whether the database has been connected to in the last month? – Blanthor Mar 28 '12 at 20:02
May be this thread will be helpful. – Alexander Mar 28 '12 at 20:16

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.