I am wondering which database holds documents? I know that the documents are held as BLOBS in the database itself, but I can't seem to figure out what database that is?

  • 2
    possible duplicate of move a database to a different drive on the same server? – Tim Gabrhel Aug 24 '11 at 20:37
  • 1
    What is wrong with the solutions I've previously provided to you? I give you an answer and you create another thread. – Tim Gabrhel Aug 24 '11 at 20:39
  • 1
    @Tim, what other solutions have you provided? I only see three other questions from Phil and none of them touch on this. Also, your possible duplicate seems like a different question to me. – Abe Miessler Aug 24 '11 at 21:00
  • 2
    I'm a little confused about the close votes on this question. The "possible duplicate" is completely different. Yes, the OP asked this in a comment on the answer by @TimGabrhel however they have every right to ask this as a new question, and it is more valuable to the community that they have done so. – Alex Angas Aug 24 '11 at 22:48
  • Thank you Alex and Abe, Tim probably didn't read the whole thing. – Phil Aug 24 '11 at 23:20

I would take a look at these two links:

They go over the various databases that SharePoint has under the hood and what their purposes are.

That being said... I would recommend staying away from directly interacting with SharePoint databases. Microsoft provides an object model that allows you to perform any actions that you should be performing. If you manually start mucking around in the database there is a good chance you will blow up your data or render your instance of SharePoint "unsupported"... Be careful!

From MSDN:

Direct modification of the SharePoint database or its data is not recommended because it puts the environment in an unsupported state.

  • +1 Don't do anything to alter the data model or directly insert/update/delete data...and while querying the database is permissible it is ill-advised. – Rob D'Oria Aug 24 '11 at 22:01

In the content database that the site uses.

Here is a pretty good article: http://sharepointsolutions.blogspot.com/2008/08/exactly-where-sharepoint-documents-are.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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