Monday, June 18, 2012

How to configure the Remote BLOB Storage(RBS) on Sharepoint Web application

Remote BLOB Storage (RBS) is an add-on feature pack for Microsoft SQL Server 2008. RBS is designed to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. If the content databases in Microsoft SharePoint Server 2010 are 4 gigabytes (GB) or larger, consider using RBS as part of your data storage solution.
We are able to enable the RBS ( Remote blob storage) for the SharePoint.

How to enable RBS on SharePoint web application.

Server Instance level settings.

1.       Open SQL configuration tool-> Start-> All Programs-> Microsoft SQL Server 2008 R2-> Configuration Too-> SQL Server Configuration Manager

In the SQL Server Configuration Manager snap right click on the SQL instance where you want to enable FILE STREAM.

1.       Click on Properties and select FILE STREAM tab

Select all check boxes and press ok.

Database level configuration.

1.       Open the Query windows from the SQL and execute following query.

EXEC sp_configure filestream_access_level, 2
2.       Now go the SQL server and select the content database on which we need to enable RBS. Eg. Suppose we have a web application and the content database for this web application is WSS_Conten_8000 then open the query windows of WSS_Content_800 database.

Execute following Queries

use [WSS_Content_8000] --- name of the content databaes
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_8000]
if not exists
(select groupname from sysfilegroups
where groupname=N'RBSFilestreamProvider')
alter database [WSS_Content_8000]
add filegroup RBSFilestreamProvider contains filestream

use [WSS_Content_8000]
alter database [WSS_Content_8000]
 add file (name = RBSFilestreamFile, filename =
to filegroup RBSFilestreamProvider
The last command will create a folder in your D: name Blogstore. This is the folder where SharePoint will store the files.

Install the RBS client library on each Web server
1.     Download setup from to local drive on the SQL server
2.     Open command prompt and run following command

msiexec /qn /lvx* rbs_install_log.txt /i RBS_x64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content_8000" DBINSTANCE="VIN-048\SHAREPOINT" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

NOTE: in above command change parameter for  DBNAME and DBINSTANCE parameter

Validate that client library install correctly.

1.    Open  content database , there will be many new tables start with mssqlrbs.. . See below image.

Enable RBS at content database level.

1.       Open powershell and run following command
$cdb = Get-SPContentDatabase WSS_Content_8000
$rbss = $cdb.RemoteBlobStorageSettings

Testing of the application

2.       Upload documents in the document library. At SharePoint level you will not see any difference but you can check the Blogstorage folder.

No comments:

Post a Comment