Remote BLOB Storage Does Not Save Your SharePoint
SharePoint stores all portal content in content databases. This means that large documents and other binary large objects (BLOBs) quickly push the databases towards the recommended 100GB maximum size limit. Item versioning settings make this even worse, as every minor or major version creates a new binary copy of the document into the database.
A brand new feature of SharePoint Server 2010 and SQL Server 2008 is Remote BLOB Storage (RBS). It allows to move BLOBs from databases to other commodity storage solutions. In theory, that would significantly reduce the need to split SharePoint content into several content databases and would ease the database management.
SQL Server 2008 ships with RBS FILESTREAM provider for the RBS solutions to connect to local databases. It also ships with RBS FILESTREAM feature for saving BLOBs directly in NTFS filesystem. But according to TechNet:
SharePoint Server 2010 does not support remote BLOB storage implementations that use the FILESTREAM feature.
That must be new addition, as the FILESTREAM usage with SP2010 is demonstrated for example in Todd Klint’s blog.
In other material, Microsoft hint that RBS can be used with storage systems such as EMC Centera or NetApp SnapManager.
This seems to imply that simply using NTFS disks as RBS stores is not possible without separately licenced storage systems. As these are not viable in many cases, sticking to old database planning methods and remembering the 100GB size limit seems to be the best way to go.
UPDATE 3.3.2010: The TechNet pages referenced in this article are updated, and there are now instructions for implementing a NTFS store using RBS and FILESTREAM provider. It seems that my original assumption was wrong, and RBS might indeed be a viable alternative.
Popularity: 4% [?]
I would understand the Technet article so that FILESTREAM _provider_ is supported, while FILESTREAM _feature_ is not.
Hi and thanks for the comment! That is also how I understood the article: the provider is supported but the feature is not. The difference between those two was not so clear when I wrote this article in the end of January. It seems that the TechNet article was updated on 10th of February. There are now clear instructions about creating a blob store in NTFS share using FILESTREAM provider. So it seems I was wrong in the article, which is good as now we can more easily utilize RBS. I will update the article as well.
Hi Arttu,
I just wrote an article on Microsoft SharePoint EBS External Blob Store and RBS Remote Blob Store API and how this can be used to get SharePoint content in external storage and not in the SQL Server. Microsoft itself does not provide a connecting solution but being a software company they provide the key: the EBS / RBS api. It’s up to a software developer to create the connection, and STEALTH Software has done that. Basically what they have done is creating a provider that separates the metadata from the content (blob’s) and store that in SQL Server. The content goes in to an external storage. This can be a private storage environment based on Caringo CAStor, ParaScale or Bizanga Store Ring. Or it can be a public environment like Windows Azure, Amazon S3 or EMC Atmos. The content can be secured with AES 256 bit encryption, so if public storage is scary it won’t be for SharePoint content.
If you would like to read more about this, please check out my article: http://www.synergy4.eu/blog/microsoft-sharepoint-ebs-external-blob-store-rbs-remote-blob-store-api-the-key-to-sharepoint-storage-solution
Configure RBS of SQL 2008 with SharePoint 2010 (Remote BLOB Storage) / Thiết đặt thông số RBS của SQL 2008 với SharePoint 2010 http://sharepointtaskmaster.blogspot.com/2011/06/configure-rbs-of-sql-2008-with.html
- FileStream Provider only offers a basic level of garbage collection.
- RBS FileStream Provider doesn’t support multiple storage tiers to help you optimize your storage cost (see my blog on SharePoint Archiving with multiple storage tiers).
- No compression or encryption options are afforded.
- RBS FileStream Provider is only supported in SharePoint 2010.
- Much more…
So before using the RBS FileStream Provider, you should be very careful in analyzing the costs of its limitations.
However StorageEdge FileStream Provider is a much better tool that provide
- StorageEdge RBS FileStream Providers also allows you to apply filters to the externalized content so you don’t need to externalize everything.
- Encryption and Compression are also supported.
- It supports throttling of various activities reducing their impact on performance in peak times.
- It also provides a rich administration interface from within SharePoint.
- Organize the externalized content in personalized folder structure.
- File names are available in externalized content. This feature is not supported in RBS FileStream Provider. You don’t know the actual name of the externalized file on disk as it is always a GUID.
Thus StorageEdge ensures that the burden of managing BLOBs is effectively off-loaded from the SQL Server.
We have implemented StoragePoint…have a look ion their website.
I am regular reader, how are you everybody?
This piece of writing posted at this web site is really good.
Hello There. I discovered your blog the use of msn.
That is an extremely smartly written article. I will
make sure to bookmark it and return to learn more of your
helpful info. Thank you for the post. I will definitely comeback.
I do love the way you have framed this particular difficulty plus it does indeed
supply us some fodder for consideration. Nevertheless, coming from
everything that I
have witnessed, I simply just
wish when the actual
opinions pack on that men and women continue to be
on issue and in no way embark upon a soap box associated with some other news of the day.
Anyway, thank you for this
superb point and even though I
can not agree with the idea in totality, I respect
the perspective.
Hey just wanted to give you a brief heads up and
let you know a few of the
images aren’t loading properly. I’m not sure why but I
think its a linking issue. I’ve tried it in
two different internet browsers and both show the same outcome.
I must show my gratitude for your generosity in support of folks
that have the need for help on the matter. Your very own commitment to
passing the message all-around had become astonishingly
beneficial and have without
exception empowered people like me to arrive at their
pursuits. The insightful
tutorial signifies a lot to me and especially to my fellow
workers. Best wishes; from all of us.
Howdy! This is my 1st comment here so I just
wanted to give a quick shout out and say I genuinely enjoy reading
through your posts. Can you recommend any other blogs/websites/forums that deal with the
same
topics? Thanks a lot!
I just could not leave your site before suggesting
that
I extremely enjoyed the standard info a person
supply on your guests? Is gonna be back incessantly to check up on new posts
Also visit my blog post :: car rentals valencia spain (Geneva)
Hello, I think your site might be having browser compatibility
issues. When I look at
your blog in Ie, it looks fine but when opening in Internet Explorer, it
has some overlapping. I just wanted to give you
a quick heads up! Other then that,
superb blog!
My web blog – http://fabsalvadorpdeiz.Soup.io/?sessid=be3b01736bca7bf0cb7236a302833a0b
I do not even know how I ended up here,
but I thought this publish was great. I
don’t know who you are but
certainly you are going to a well-known blogger for those who aren’t already
Cheers!
Here is my blog :: Spanish property Albox, Christel,
advertising and ***********
with Adwords. Anyway I’m adding this RSS to my email and could glance out
for a lot more of your respective intriguing content.
Make sure you update this again soon..
Oh my goodness! a tremendous article dude. Thank you Nevertheless
I am experiencing concern with ur rss . Don’t know why
Unable
to subscribe to it. Is there anyone getting equivalent rss drawback?
Anyone who is aware of kindly respond. Thnkxxx
I take pleasure in, cause I discovered just what I was looking for.
You have ended my four day lengthy hunt! God Bless you man.
Have a nice day. Bye
For newest news you have to vsit world wide web and on the web I
found this website as a most excellent web site for newest updates.
Everything is very open with a very clear description of the challenges.
It was really informative. Your website is useful. Many thanks for sharing!
I’m surprised the list is missing Lagos, That city has been growing at an insane
We recommended the best web platform – geile frau – for free sexy chat with hot young girls!
With respect !!!