In sharepoint 2010, can i span a Site collection(Document center) in multiple Contentdatabases?

Question

Hi,

actually we are running in to content database size limit issue, right now in production our content database has grown up to 200gb+. so we are thinking to create a new webapplication and create more than 2 or 3 content databases and attach it to the webapplication and create a site collection of Document center. so my question is, over a period of time if my Document center grows 200gb+ then will SharePoint transfer my new data in to another content database? is this possible in SharePoint 2010, if yes(just assuming) where do i configure; after 200gb, point to other contentdb

plz give some solution and plz do comment that our assumption is correct or not.

Answer 1

Sri, 

  You cannot have a single site collection spanning multiple content databases. 

 

---

V

Answer 2

No, you cannot have a single site collection span multiple content databases. Its not possible, sorry.

I'd recommend taking a look at a couple of Microsoft resources on Technet for more information on this subject:

• In general, the SharePoint Server 2010 Capacity Management Resource Center has a lot of great information and articles for you to review: http://technet.microsoft.com/en-us/sharepoint/ff601870
• Specifically, you'll want to look at this article: http://technet.microsoft.com/en-us/library/cc298801.aspx. There's a section in it titled "Limit content database size to improve manageability" that talks about the 200 GB limit you're familiar with, but has some additional good info to consider. First, you can go over the 100 GB limit for site collection or the 200 GB limit for content databases if its the only site collection in the database, but you need to keep in mind that you can't use SharePoint's built-in backup/restore tools to protect it. Second, if you're going to be putting a lot of large files in that database (such as large documents in your Doc Center), then you will want to consider using Remote BLOB Storage (RBS) as the backend storage provider for that database.

Does that help?

John

---

MCITP and MCTS: SharePoint, Virtualization, Project Server 2007
My books on Amazon: The SharePoint 2010 Disaster Recovery Guide and The SharePoint 2007 Disaster Recovery Guide.
My blog: My Central Admin.

Answer 3

Thanks John, it was much helpful, the main misconception was site collection can span multiple Content databases, this was clarified.and thanks for suggesting MS links.

Thanks 'V'...

Answer 4

Hi ASK4SP,

Have you fixed this issue? if yes how did you approach this?

Regards Amit

Answer 5

Hi Amit,

we have created multiple site collection of team sites with one Content DB each.

Regards,

Srikanth || ASK4SP

Answer 6

Hi Srikanth,

Thanks for you reply. I do appreciate your help.

Regards Amit