I am working on an on-premise sharepoint enterprise server 2013. currently i have the following info:-

  1. i have one web application + one content database.
  2. I have 10 site collections.

now when i create my site collections i always specify not to have any Quota, as follow:-

enter image description here

so can anyone adivce if there are any limitation about the size of each of the site collections? or since i did not specify any Quota for the site collections,, so each site collection can have dynamic maximum size as long as the database server have space ?

1 Answer 1


All sizing information can be found on https://technet.microsoft.com/en-us/library/cc262787.aspx#Limits and boundaries

A site collection has no specific size limitation, but a single content database is limited to 200GB in general usage scenarios, and 4TB absolute maximum.

It is however recommended to keep the site collection size under 100GB

A site collection can be as large as the content database size limit for the applicable usage scenario. For more information about the different content database size limits for specific usage scenarios, see the Content database limits table in this article. In general, we strongly recommend limiting the size of site collections to 100 GB for the following reasons:

  • Certain site collection actions, such as site collection backup/restore or the Windows PowerShell cmdlet Move-SPSite, cause large SQL Server operations which can affect performance or fail if other site collections are active in the same database. For more information, see Move-SPSite.
  • SharePoint site collection backup and restore is only supported for a maximum site collection size of 100 GB. For larger site collections, the complete content database must be backed up. If multiple site collections larger than 100 GB are contained in a single content database, backup and restore operations can take a long time and are at risk of failure.
  • so seems the site collection can hold as much as the content DB can hold... but Microsoft does not recommend to extend the size of a site collection to more than 100GB because backup/restore site collection will not longer be supported, and we will have to backup the whole content database and can not backup single site collections... is this correct ?
    – John John
    Apr 26, 2017 at 12:29
  • @johnG this seems to be correct indeed. (edited my answer to elaborate) however, nothing is stopping you from separating content DB's for your site collections, which might be useful for backup/restore scenarios
    – Nsevens
    Apr 26, 2017 at 12:45
  • but not sure what do you exactly mean by "however, nothing is stopping you from separating content DB's for your site collections, which might be useful for backup/restore scenarios " ??
    – John John
    Apr 26, 2017 at 13:06
  • You can create multiple content databases, which can each hold 1 or more site collections. To avoid backup/restore issues, it might be useful to limit the content databases to hold MAX 1 site collection - so when restoring of a site collection is needed, this can easily be done by restoring the relevant content database
    – Nsevens
    Apr 27, 2017 at 13:30
  • 1
    Only very little. Storage is 99% relative to usage of your site collection (document size, ...).
    – Nsevens
    Apr 28, 2017 at 9:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.