Remote BLOB Storage Does Not Save Your SharePoint

March 3 2010 21 comments

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% [?]

21 comments to “Remote BLOB Storage Does Not Save Your SharePoint”

  1. Jussi Palo says:

    I would understand the Technet article so that FILESTREAM _provider_ is supported, while FILESTREAM _feature_ is not.

  2. Arttu Arstila says:

    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.

  3. 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

  4. 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

  5. Elvira says:

    - 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.

  6. Pungi says:

    We have implemented StoragePoint…have a look ion their website.

  7. I am regular reader, how are you everybody?
    This piece of writing posted at this web site is really good.

  8. Lukas says:

    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.

  9. 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.

  10. 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.

  11. Shoshana says:

    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.

  12. 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!

  13. Geneva says:

    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)

  14. 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

  15. Christel says:

    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,

  16. Rolland says:

    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..

  17. Leila says:

    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

  18. Dorothea says:

    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

  19. 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.

  20. Carol says:

    Everything is very open with a very clear description of the challenges.
    It was really informative. Your website is useful. Many thanks for sharing!

  21. partykins says:

    I’m surprised the list is missing Lagos, That city has been growing at an insane

Leave a Reply