Enable FILESTREAM (RBS) for SharePoint 2010

Technet article: http://technet.microsoft.com/en-us/library/ee748631%28office.14%29.aspx

Run the following commands in SQL Server management query window. Change the database name as needed.

use [WSS_Content]

if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')

create master key encryption by password = N'Admin Key Password !2#4'



use [WSS_Content]

if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

alter database [WSS_Content]

add filegroup RBSFilestreamProvider contains filestream

use [WSS_Content]

alter database [WSS_Content]

add file (name = RBSFilestreamFile, filename = 'c:\Blob')

to filegroup RBSFilestreamProvider



After activating this three commands you will find some files in the new folder c:\blob. Important. This folder will be created by the sql command.



Install RBS

http://go.microsoft.com/fwlink/?LinkId=177388



Do not run the msi file directly.

On the database and first SQL server run the following command:

msiexec /qn /lvx* rbs_install_log.txt /i RBS_X64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content" DBINSTANCE="" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

Fill in the SQL instance name for specific SQL server instances.

Run the following command on all other SharePoint servers:

msiexec /qn /lvx* rbs_install_log.txt /i RBS_X64.msi DBNAME="WSS_Content" DBINSTANCE="" ADDLOCAL="Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer"

Check rbs_install_log.txt after installation:

>>>> Product: SQL Remote Blob Storage -- Installation completed successfully.

To enable RBS on a specific web application open the SharePoint Management Shell on run this commands

$cdb = Get-SPContentDatabase –WebApplication http://moss2010server

$rbss = $cdb.RemoteBlobStorageSettings

$rbss.Installed()

$rbss.Enable()

$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])

$rbss



After the activation you can find additionals files and folder in the blob folder



After uploading a file (in this example rbs_install_log.txt) in a document library



You will find new folders and files (with guid names) in the blob directory structure.



If you upload a new version of this file, the new file will be place in the same folder with a new name. SharePoint does not save the difference only.