How to install and configure Remote Blob Storage (RBS) on SharePoint Server 2010

Video length: 11:54

Video description: This video walks through the process of installing & configuring Remote Blob Storage (RBS) for a Microsoft SQL Server 2008 database server that supports a SharePoint Server 2010 2010 farm.

Documented video steps below:

To use RBS, you must do the following:

  1. Enable FILESTREAM on the database server
  2. Provision a BLOB store for each content database
  3. Install the RBS client library on each Web server
  4. Enable RBS for each content database
  5. Test the RBS installation
  6. (Optional) Configure Minimum Blob Storage Size

The user account performing the procedures must have the following memberships:

  • Administrators group on the Web servers and application servers.
  • SQL Server dbcreator and securityadmin fixed server roles on the computer that is running SQL Server 2008.

Enable FILESTREAM on the database server

  • Log into your SQL Server
  • Launch SQL Server Configuration Manager, Select SQL Server Services, locate your instance, Right-click and select Properties, switch to the FILESTREAM tab, select all checkboxes (3 of them,) click Apply, click OK, and Exit out as the image below:

  • In SQL Server Management Studio, click New Query to display the Query Editor.
  • In Query Editor, enter and execute the following:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE

Provision a BLOB store for each content database

  • Log into your SQL Server
  • Launch SQL Server Management Studio and connect to the instance of SQL Server that hosts your content databases.
  • Paste the following SQL queries in the Query pane and execute them in the sequence lists.
  • Replace [WSS_Content] with the content database name
  • Replace c:\BlobStore with the volum\directoy in which you want the BLBO store created
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:\Blobstore’)
to filegroup RBSFilestreamProvider

Install the RBS client library on each Web server

  • Log into your Web Front End Server (WFE)
  • Download the RBS_x64.msi file from: http://go.microsoft.com/fwlink/p/?LinkID=165839&clcid=0x409
  • On the first WFE, open a Command Prompt with ‘Run as Administrator’
  • Copy and paste the following command
  • Replace WSS_Content with the database name
  • Replace DBInstanceName with your database instance: Server or Server/Instance
  • Navigate and run the command from the location of where you downloaded the RBS_x64.msi file
msiexec /qn /lvx* rbs_install_log.txt /i RBS_X64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME=”WSS_Content” DBINSTANCE=”DBInstanceName” FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1
  • Open the rbs_install_log.txt file from the same folder location and look for the following line
Product: SQL Remote Blob Storage — Configuration completed successfully
  • It may take about a minute for the entire process to complete
  • You can switch to the database server, open the database tables and look for tables preceded by letter “mssqlrbs”
  • For additional web servers, same as the above but run the following command instead
msiexec /qn /lvx* rbs_install_log.txt /i RBS_x64.msi DBNAME=”WSS_Content” DBINSTANCE=”DBInstanceName” ADDLOCAL=Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer

 Enable RBS for each Content Database

  • Log into your Web Front End Server (WFE)
  • Launch SharePoint 2010 Management Shell
  • Copy and paste the following command
  • Replace <contentDatabaseName> with your database name
$cdb = Get-SPContentDatabase <ContentDatabaseName>
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
$rbss

 Test the RBS Installation

  • Log into/create a site collection pointing to the database you’ve been working on and upload a document
  • Log into the SQL Server and browse to the blob directory (C:\Blobstore in our example) and open the file with the most recent date. You can confirm by size of the file.

 Configure minimum Blob Storage Size

  • Log into any Web Front End Server (WFE)
  • Launch SharePoint 2010 Management Shell
  • Copy and paste the following command
  • Replace WSS_Content with your database name
  • Replace the size of 1048576 (1 MB) to your liking (in bytes)
$database = Get-SPContentDatabase WSS_Content
$database.RemoteBlobStorageSettings.MinimumBlobStorageSize=1048576
$database.Update()

 Links

Leave a Comment