Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Install and configure RBS with a 3rd party provider (SharePoint Server 2010)

Published: April 10, 2012

This article describes how to install and configure Remote BLOB Storage (RBS) for a database server that supports a Microsoft SharePoint Server 2010 farm.

Tip Tip:

RBS can be used with SQL Server 2008 or SQL Server 2008 R2. However, you must install the SQL Server 2008 R2 RBS binaries. The binaries are part of the SQL Server 2008 Feature Pack, October 2008 and the SQL Server 2008 R2 Feature Pack.

Important Important:

This solution uses a 3rd-party provider. Before continuing, be sure to read the instructions from the manufacturer of the provider.

Do not directly access BLOBs when using 3rd party providers. Always access these BLOBs by using SharePoint Server 2010.

To use RBS, you must do the following:

The user account that you use to perform the procedures that are described in this article 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.

Install the RBS client library on each Web server

You must install RBS client library on all Web servers in the SharePoint farm. The RBS client library is installed only once per Web server, but RBS is configured separately for each associated content database. The client library consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server.

Warning Warning:

Do not install RBS by running the RBS.msi file and starting the Install SQL Remote BLOB Storage wizard. The wizard sets certain default values that are not recommended for SharePoint Server 2010.

To install the RBS client library on the on the first Web server

  1. On any Web server, browse to http://go.microsoft.com/fwlink/?LinkID=188395&clcid=0x409 if you are running SQL Server 2008 or http://download.microsoft.com/download/E/4/8/E48816F7-4612-432E-B135-0F90C0211701/RBS_X64.msi if you are running SQL Server 2008 R2 and download the MSI file for 64-bit platforms.

  2. Click Start, click Run, type cmd into the Run text box, and then click OK.

  3. Copy and paste the following command into the Command Prompt window. Replace WSS_Content with the database name, replace RBS with “RBS.msi” if you are running SQL Server 2008 R2 or “RBS_64.msi” if you are running SQL Server 2008, and replace DBInstanceName with the SQL Server instance name. You should run this command by using the specific database name and SQL Server instance name only one time. The operation should finish within approximately one minute.

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

To install the RBS client library on all additional Web and application servers

  1. On a Web server, download the RBS.msi at http://go.microsoft.com/fwlink/?LinkID=188395&clcid=0x409.

  2. Click Start, click Run, type cmd into the Run text box, and then click OK.

  3. Copy and paste the following command into the Command Prompt window. Replace WSS_Content with the database name, and replace DBInstanceName with the name of the SQL Server instance. The operation should finish within approximately one minute.

    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi DBNAME="WSS_Content" DBINSTANCE="DBInstanceName" ADDLOCAL=Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer
    
  4. Repeat this procedure for all Web servers and application servers in the SharePoint farm.

To confirm the RBS client library installation

  1. The rbs_install_log.txt log file is created in the same location as the RBS.msi file. Open the rbs_install_log.txt log file by using a text editor and scroll toward the bottom of the file. Within the last 20 lines of the end of the file, an entry should read as follows: Product: SQL Remote Blob Storage – Installation completed successfully.

  2. On the computer that is running SQL Server 2008, verify that the RBS tables were created in the content database. Several tables should be listed under the content database that have names that are preceded by the letters "mssqlrbs".

Install the third-party provider

The steps that you use to install the third-party provider will vary between manufacturers. Be sure to follow the instructions from the manufacturer of the provider.

Enable RBS for each content database

You must enable RBS on one Web server in the SharePoint farm. It is not important which Web server that you select for this activity, as long as RBS was installed on it by using the previous procedure. You must perform this procedure once for each content database.

note Note:

You can only enable RBS by using Windows PowerShell.

To enable RBS by using Windows PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. At the Windows PowerShell command prompt, type the following command:

    $cdb = Get-SPContentDatabase <ContentDatabaseName>
    $rbss = $cdb.RemoteBlobStorageSettings
    $rbss.Installed()
    $rbss.Enable()
    $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
    $rbss
    

    Where:

    • <ContentDatabaseName> is the name of the content database.

For more information, see Get-SPContentDatabase.

Test the RBS installation

You should test the RBS installation on one Web server in the SharePoint farm to make sure that the system works correctly.

To test the RBS data store

  1. On the computer that contains the RBS data store, click Start, and then click Computer.

  2. Browse to the RBS data store directory.

  3. Confirm that the folder is empty.

  4. On the SharePoint farm, upload a file that is at least 100 kilobytes (KB) to a document library.

  5. On the computer that contains the RBS data store, click Start, and then click Computer.

  6. Browse to the RBS data store directory.

  7. Browse to the file list and open the file that has the most recent changed date. This should be the file that you uploaded.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.