Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
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
add comment

2 Answers

up vote 6 down vote accepted

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.

share|improve this answer
    
+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
    
This is what I was looking for thank you! –  Phil Aug 26 '11 at 14:36
add comment

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

share|improve this answer
add comment

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.