Remote Blob Storage (RBS ) on Sharepoint 2013

Each content database that you want to use RBS with must have a BLOB store provisioned for use.

 Follow these steps to provision a BLOB Store.

use [WSS_Content_RBS]

if not exists

(select * from sys.symmetric_keys

where name = N'##MS_DatabaseMasterKey##')

create master key encryption by password = N'Admin Key Password yourpassword'

********

use [WSS_Content_rbs]

if not exists

(select groupname from sysfilegroups

where groupname=N'RBSFilestreamProvider')

alter database [WSS_Content_rbs]

add filegroup RBSFilestreamProvider contains filestream

use [WSS_Content_rbs]

alter database [WSS_Content_rbs]

add file (name = RBSFilestreamFile, filename =

'c:\DemoRBS')

to filegroup RBSFilestreamProvider

Validate new folder

Install the RBS Client Library on the Web Server

Even though each database is configured separately for the BLOB store, you will only need to install the RBS client once on the web server.

• Download  RBS_amd64.msi file.

• Open CMD and type the command (shown below), then press Enter to run it. You will need to change WSS_Content to reflect your database name and DBInstanceName with your SQL Server instance.

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

After installing RBS, it now must be enabled on at least one web server in a SharePoint farm. The only way to enable RBS is through PowerShell, using the following cmdlets.

 You will need to change the ContentDatabaseName by your database name.