In this article I am describing about how to install and configure Remote BLOB Storage (RBS) with theFILESTREAM provider on a Microsoft SQL Server 2008 database server that supports a Microsoft SharePoint Server 2010 system. RBS is typically recommended in the case where the content databases are 4 gigabytes (GB) or larger.SharePoint stores the files (or the blobs) in content database. The advantage of that approach is it simplifies the backup and restores process. We can back up a site collection related data in one file. The disadvantage is the database size can be enormous if Site contains large number of files. It may a critical problem if you use SQL Server Express Edition which has a limitation in database file size. RBS is a library API set that is incorporated as an add-on feature pack for Microsoft SQL Server 2008 and Microsoft SQL Server 2008 Express. RBS is designed to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. RBS ships with the RBSFILESTREAM provider, which uses the RBS APIs to store BLOBs.We can configure SharePoint to stores the blob in the file system, instead of in database by possible by leveraging FILESTREAM feature of SQL Server 2008 and Remote BLOB Storage (RBS). With SharePoint 2010, the Remote Blob Storage (RBS) functionality allows putting documents into the database file system instead of the database itself. Each content database is located in a specific section of the file system where all the documents are stored.Enable File Stream in SQL Server
Install RBS on Web Server
To enable RBS
To test the RBS data store
Destin Joy is a Microsoft MVP on SharePoint Server. He isan author, speaker and a blogger in Microsoft technology. Currently Destin isin the final phase of creating his second EBook on “SharePoint 2010 CapacityPlanning”, which will be published in C# corner.
The MVP Monday Series is created by Melissa Travers. In this series we work to provide readers with a guest post from an MVP every Monday. Melissa is a Community Program Manager for Dynamics, Excel, Office 365, Platforms and SharePoint in the United States. She has been working with MVPs since her early days as Microsoft Exchange Support Engineer when MVPs would answer all the questions in the old newsgroups before she could get to them.
Very Informative article. Thanks Destin
Good article Destin
Great Article Destin. I have a question I was hoping you could help me with? I have RBS installed and enabled on my SP WFE. I check and it is enabled on the DB. When I upload files a folder in my Blobstor folder is created, but inside only 1 files exists and it is 0KB in size. Am I missing something? All files were 5MB or bigger and uploaded fine, it just appears they are not using RBS as they should. Any help is appreciated.
mslomanski AT gmail.com
I want to use Windows azure as file storage instead of local drive. How that would be possible?
I have the same problem as Mike Slomanski, my BLOB folder is empty :-/
Still no idea?
Really helpful information, although i'm getting an error when i run this query
alter database [WSS_Content_ad1f26b35c0d4f739260847dd6c00c78]
add file (name = RBSFilestreamFile, filename =
to filegroup RBSFilestreamProvider
Msg 5135, Level 16, State 2, Line 2
The path ' S:\Storage ' cannot be used for FILESTREAM files. For information about supported paths, see SQL Server Books Online.
Msg 5009, Level 16, State 14, Line 2
One or more files listed in the statement could not be found or could not be initialized.
My file path is NTFS nor sure what i need to correct and assistance would be very much appreciated.
Very good article which you composed for all. Thanks!!!
I need some more clarification which is stick in my mind
1. How do we set the file size for rbs
2. How do we set what are the file type need to allow for rbs
3. How do we set older date files that we need to achieve in rbs
Please help to answer the above question with example
Thanks in advance