Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 search webpart - query suggestions 5 37
SharePoint 2013 6 24
SharePoint 2013 Blog Template 2 36
Hyper V cluster 2 31
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
A safe way to clean winsxs folder from your windows server 2008 R2 editions
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…
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 …

920 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now