Solved

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

Posted on 2010-09-09
3
575 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

756 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