• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Content Database for Sharepoint

Does the data for sites are stored in a content database ?

Suppose I have another content database "LONDON" beside default content database "WSS_Content" where the web application http://portal/ is mounted.

Can I mount the content database "LONDON" under http://portal/sites/london, or I need to create another web application (eg. http://portal:8088) and mount the content database under the new web application ?

Tks
0
AXISHK
Asked:
AXISHK
  • 2
1 Solution
 
dhawalsethCommented:
Hi AxisHK,

The content database in SharePoint is associated to Web-Application and can hold a certain number of Site-Collections inside it.
You are correct here, that you need to create a new web-application to mount your other content Database (e.g. LONDON).
I am sharing a link which has some good FAQs and Powershell commands to help you.
http://sharepointrelated.com/2012/07/11/content-database-infrastructure-design-and-faq-sharepoint-2010/

Happy to help. Enjoy!!
0
 
AXISHKAuthor Commented:
Tks.

One question, a web application hosts several content database but a site can only be assigned to one web application, correct ?

Why the https://portal.contoso.com be mounted to two different contentDB, intranet_ContentDB & HR_ContentDB ?

How to does it work ?
0
 
dhawalsethCommented:
My bad, a correction to my statement- Content-Databases are associated with Site Collections. Each site-collection can be associated to only one content database.
Also, you can share one content database across multiple site collections. But as the data will increase the performance of the database will go down.

Refer to the below link to have more information:
http://books.google.co.in/books?id=c-BOVIJ3KyQC&pg=PA10&lpg=PA10&dq=content+database+per+web+application&source=bl&ots=csaHVBwo1q&sig=ebr34WRyKAIR3swx9TPYGp5uOrs&hl=en&sa=X&ei=wob1U_GtGpb-yQTl6IGACA&ved=0CHcQ6AEwCQ#v=onepage&q=content%20database%20per%20web%20application&f=false

Something funny but serious
http://blogs.technet.com/b/sharepointcomic/archive/2009/07/21/unique-content-database-per-sharepoint-site-collection.aspx
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now