Solved

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

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
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 walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

773 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