?
Solved

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

Posted on 2010-09-09
3
Medium Priority
?
598 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
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
chapmanjw earned 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Suggested Courses

839 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