Sharepoint Databases

Question

Hi guys Please help me understand the Content database and config database in sharepoint. Which one stores what with an example.How are the documents stored Thanks in advance

Vipul Kelkar · Answer

Ok..got it..thanks for your assistance

Bhushan Gawale · Answer

Hi yes you are right .. everything comes up from content database of sharepoint site and about web part .. that depends what you are displaying in web part .. you can also display data from file system in a webpart but precisely you can say that web part data and web part gets stored in Content Database (there is kind of encryption technique that sharepoint follows to store contents of sharepoint site into Content Database)

Vipul Kelkar · Answer

Thanks bhushan So is it that all the content that we see on a sharepoint ste goes in the content database..I mean..say if i have a web part on my site...the contents of the web part a Serialized and added to the content database ??

Bhushan Gawale · Answer

Hi SharePoint has a concept of Configuration Database and Content Database. If this can be explained briefly like this Configuration database is the one which store all configuration Information of your SharePoint farm or in other words  that stores set of setting which you do by using your central administration GUI tool  and about Content Database - they are the databases created at the time of creating SharePoint Web Applicataions for storing web application specific data one thing to be note is that  there is only one configuration database per farm and there can be multiple content databases in your farm (according to web applications) so naturally documents in the document library of sharepoint are stored stored in Content Database of respective web application (there is a table named AllDocs in Content Database in which documents in site gets stored )