Link to home
Start Free TrialLog in
Avatar of ParaGlow
ParaGlow

asked on

File size limit in SharePoint 2010

I had this question after viewing VBA in SharePoint.

Is there still a SharePoint file size limit of 2 GB per Excel file ?  Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have just Googled "Sharepoint limits" and it shows the following headlines:

Limits for SharePoint Online in Office 365 Business Essentials and Office 365 Business Premium
FEATURE                              DESCRIPTION
File upload limit                      10 GB per file for drag and drop uploads. All other upload methods have a 2 GB limit.
File attachment size limit      250 MB
Sync limits                              5,000 items in site libraries, including files and folders.

Full link:
https://support.office.com/en-gb/article/SharePoint-Online-software-boundaries-and-limits-8f34ff47-b749-408b-abc0-b605e1f6d498
Yes, 2 GB limit if not using BLOB offloading for SharePoint 2010.  This is a SQL limitation, not SharePoint.  What the gentleman posted above will not apply to an on  premises SharePoint 2010 farm.  Please reference: https://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#ListLibrary
It is also a SharePoint limit.  So in answer to the question, there is "still" a file size limit of 2GB per file, if you are running SP 2013 or below.  

SharePoint 2016 and SharePoint Online now supports 10GB file sizes.  This is due to SharePoint now using BITS rather than Cobalt Protocol (FSS HTTP) which was limited to 2GB.  Ref: https://channel9.msdn.com/Events/Ignite/2015/BRK2188
It is a Sharepoint limit because it is a SQL limitation. This is why offloading BLOBs can get around it as you take SQL limitation away.