Nick Grattan's Blog

About Microsoft SharePoint, .NET, Natural Language Processing and Machine Learning

Storing BLOBs Externally in SharePoint 2007

with 2 comments

Documents in SharePoint Document Libraries are stored in the SQL Server database. In most situations this works well – backing up the SQL Server content database backs up all the documents in a consistent way.

However, for storing Binary Large Objects (BLOBs) may be inefficient and costly. It may be more efficient to store such BLOBs in the file system and then link these files to SharePoint Document Libraries.

This can now be done through the ISPExternalBinaryProvider interface. Prior to SharePoint 2007 SP1 this component was available as a hot fix, but is now included mainstream.

The interface is documented here: http://msdn2.microsoft.com/en-us/library/bb802976.aspx.

Advertisements

Written by Nick Grattan

January 17, 2008 at 12:54 pm

2 Responses

Subscribe to comments with RSS.

  1. Hi Nick,
    there are some serious downsides with the external storage.
    (see my blog: http://www.hezser.de/blog/Lists/Beitraege/Post.aspx?ID=75)
    – With the current version only the SPFarm is supported. Meaning ALL content will be stored externally
    – After you have implemented an external storage provider, all new documents will be stored in this place. To move old documents, you could do a Backup/Retore of your content.
    – Changing a document will create a new blob and not disposing the old one. You have to do this manually (you can implement garbage collection)!

    René

    René Hézser

    October 1, 2008 at 9:56 am

  2. René, thanks for your comments – very useful, Regards, Nick

    Nick Grattan

    October 1, 2008 at 12:18 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: