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?

1 Answer 1


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.

  • 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, 2012 at 20:02
  • 2
    May be this thread will be helpful.
    – Alexander
    Mar 28, 2012 at 20:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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