Solved

Utilizing SharePoint Foundation 2010 with BLOB extender to avoid 4 GB limit of SQL Express

Posted on 2010-09-09
3
580 Views
Last Modified: 2012-05-10
Hi Everyone,

If I'd like to deploy SharePoint 2010 Foundation with Express DB (no SQL Server) what's the limitation ?

and suppose i have implemented BLOB extender from freeware 3rd party http://www.avepoint.com/sharepoint-storage-extender-docave/ does that means i can deploy more than 4 GB of data and it should perform faster since the SQL Express is not loaded with BLOB (document binaries).

Can anyone clarify this matter please ?

Thanks.
0
Comment
Question by:jjoz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
chapmanjw earned 500 total points
ID: 33637462
Yes, you have it correctly.  SQL Express is limited to 4 GB of data.  With the BLOB extender, your file content is not being stored in SQL and therefore increases your capacity.

It is not necessarily faster to go External BLOB vs SQL Storage, it all depends on your infrastructure.  You probably won't notice much of a difference in performance if everything is setup correctly.
0
 
LVL 1

Author Comment

by:jjoz
ID: 33637739
ah great, so in this case i can utilize the freeware edition of SharePoint 2010 practically unlimited :-)
0
 
LVL 1

Author Closing Comment

by:jjoz
ID: 33659666
thanks man !
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question