Capacity Management for Site Collection Over 100 GB RRS feed

  • Question

  • Hi,

    We have this particular scenario where, we need to migrate some 1000 Site Collections (WSS 2.0) as Subsites (WSS3.0) inside one Site Collection . Now how we are migrating is totally irrelevant for this post (using a Custom Migration Tool).

    Now the problem we are faced with is these 1000 Site Collections totals to around 194 Gb of data. And as Microsoft recommends as Soft Limit of 100GB for a Content Database, this is posing an issue for us. We are totally aware that a Site Collection can best be mapped to only one Content Database.

    So just wanted to know, if there any way around this, or any suggestion in situations like these.



    Soptik Dutta
    Monday, February 28, 2011 4:03 PM


All replies

  • You have to reorganize your SharePoint site collection. One SharePoint Web Application can have more than one database. But unfortunately one site collection can be assigned just to one database. This is good link how to work with SharePoint databases: http://www.mssqltips.com/tip.asp?tip=1777. This is about planning: http://technet.microsoft.com/en-us/library/cc262787(office.12).aspx
    • Marked as answer by Soptik Dutta Tuesday, March 1, 2011 10:01 AM
    Monday, February 28, 2011 4:26 PM
  • Many thanks for the reply.

    Then the other way around is there a way to have two different site-collections but having same url, or something that the end users, does not understand the difference between the urls. Or for that matter if we can have two different web applications with the same url.


    That way we would divide the sub sites between the two Site Collections or Web Application whatever.

    Soptik Dutta
    Monday, February 28, 2011 4:50 PM
  • You can create another site collection with the same base URL but if you will create new Web Application it will have different URL or port number.
    Monday, February 28, 2011 4:59 PM
  • ok. Guess need to create two site collections only.  Thanks again.
    Soptik Dutta
    Tuesday, March 1, 2011 10:01 AM