Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Limit on document size in site collection

  Asked By: Imran    Date: Jun 12    Category: Sharepoint    Views: 1818

Using WSS v3. I am looking for a storage limit per site collection. We are
having 2 document libraries that will contain around 100 documents each on 1MB.
There will we 100 * 100 websites in each site collection containing these
libraries. All in all, the result will be about 2000GB or 2TB for each site
collection only in document storage space.

Does site collection have any size limit on document storage like 200GB?



4 Answers Found

Answer #1    Answered By: Mason Salazar     Answered On: Jun 12

You can store as much data as you want in a site  Collection. The problem is in
backing it up. You need to consider your recovery strategy. All content for a
Site collection  resides in a single database and the thought of having to back
up that much data at once... It is recommended that you try to keep your
databases to under 120gb in size

Answer #2    Answered By: Jesus Davis     Answered On: Jun 12

There are two practical size  limits on site  collection storage. The first is
the physical limit  on the size of a SQL database. That's over 524,000
Terabytes. I suspect you will run out of disk space long before you hit that
limit. But the second limitation is more critical. that is the size of a
database that your backup and restore system can handle in a reasonable time
limit. Having a 2 Terabyte SQL database will do you no good if you can 't
backup and restore it in a reasonable length of time. So the actual storage
limit for a site collection  is dependent on your backup and recovery system not
SQL or SharePoint. Most companies with standard equipment suggest keeping an
individual content database to about 50-100 GB.

Answer #3    Answered By: Narasimha Kamane     Answered On: Jun 12

Well said, and I would add that you'll most likely have locking/blocking issues
the larger your site  collections get. Large transactions can perform a table
lock and cause (temporararily), subsequent requests to be blocked. This is a
primary issue when dealing with large site collections. Either a few users and
really large site collections, or lots of users and small site collections. What
you want to avoid is really large site collections with lots of users. This
almost guarantees you'll have locking/blocking at the SQL level.

Answer #4    Answered By: Fidel Crane     Answered On: Jun 12

Your limitation will be at the content database. Not so much a limitation, but
a best practice based on your organization's SLA. Microsoft recommends that you
keep your content db's under 100 GB in order to be able to restore them in a
reasonable timeframe.

Didn't find what you were looking for? Find more on Limit on document size in site collection Or get search suggestion and latest updates.