With the release of SharePoint 2010 SP1 Microsoft changed the supported data size limits for SharePoint content databases.

Prior to SP1

Item

Limit

Content Database, Collaboration scenarios

200 GB

Content Database, Archive scenarios

1 TB

Number of items in a content database

30 million

SP1

Item

Limit

Content Database, Collaboration scenarios

4 TB (see notes below)

Content Database, Archive scenarios

No explicit limit (see notes below)

Number of items in a content database

60 million

For a SharePoint content database up to 4 TB you need to additionally plan for the following two requirements:

  • Requires disk sub-system performance of 0.25 IOPS per GB, 2 IOPS per GB is recommended for optimal performance.
  • Requires plans for high availability, disaster recovery, future capacity, and performance testing.

For a SharePoint content database over 4TB specifically for a Document Archive scenario you are required to additionally plan for the following:

  • SharePoint sites must be based on Document Center or Records Center site templates.
  • Less than 5% of content is actively read from each month and less than 1% of content is actively written to.
  • Do not use alerts, workflows, link fix-ups, or item level security on any SharePoint objects in the content database. Document archive content databases can accept documents as a result of Content Routing workflow.

Read more on SharePoint Server 2010 capacity management: Software boundaries and limits.