Set BLOB storage for each content database
After you enable and configure FILESTREAM, follow these procedures to set up BLOB storage in the file system. You must set up BLOB storage for each content database to which you want to use RBS.
set up BLOB storage
Verify that the user account that performs these steps is a member of the db_owner fixed database role on each database for which you want to configure RBS.
Click Start, All Programs, Microsoft SQL Server 2008, and then SQL Server Management Studio.
Connect to the instance of SQL Server that hosts the content database.
Expand Databases.
Click the content database for which you want to create BLOB storage, and then click New Query.
Paste the following SQL query in the query pane, and then execute them in the order listed. In each case, replace [WSS_Content] with the content database name and replace C:\BlobStore with the volume \ directory where you want to create the BLOB store. The setup process creates a folder at the location you specify. Please note that you can only set up BLOB storage once. If you try to set the same BLOB store more than once, you will receive an error.
Use [Wss_content]if NOT EXISTS (SELECT * from sys.symmetric_keys where name = N ' # #MS_DatabaseMasterKey # # ') Create Master Ke Y 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
reuse use [WSS_Content]ALTER DATABASE [wss_content] Add file (name = rbsfilestreamfile, filename = ' c:\Blobstore ') to filegroup Rbsfilestreamprov Ider
Install the RBS client library on each WEB server
You must install the 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 includes a client dynamic-link library (DLL) that is linked to a user application and a set of stored procedures that are installed on SQL Server.
Install the RBS client library on the first WEB server
Verify that the user account that performs these steps is a member of the Administrators group on the computer on which the library is installed.
On any WEB server, browse to http://go.microsoft.com/fwlink/p/?LinkId=271938 and download the Rbs_amd64.msi file.
Click Start, click Run, type cmdin the Run text box, and then click OK.
Copy and paste the following command into the Command Prompt window. Replace wss_content with the database name and replace dbinstancename with the SQL Server instance name. You should only run this command once with a specific database name and the SQL Server instance name. This operation should be completed in about one minute.
Copymsiexec/qn/lvx* rbs_install_log.txt/i rbs_amd64.msi trustservercertificate=true FILEGROUP=PRIMARY DBNAME= "WSS_ Content "dbinstance=" Dbinstancename "Filestreamfilegroup=rbsfilestreamprovider filestreamstorename= Filestreamprovider_1
Install the RBS client library on all other WEB servers and application servers
Verify that the user account that performs these steps is a member of the Administrators group on the computer on which the library is installed.
On any WEB server, browse to http://go.microsoft.com/fwlink/p/?LinkId=271938 and download the Rbs_amd64.msi file.
Click Start, click Run, type cmdin the Run text box, and then click OK.
Copy and paste the following command into the Command Prompt window. Replace wss_content with the database name and replace dbinstancename with the SQL Server instance name. This operation should be completed in about one minute.
Copymsiexec/qn/lvx* rbs_install_log.txt/i rbs_amd64.msi dbname= "wss_content" dbinstance= "DBInstanceName" ADDLOCAL= Client,docs,maintainer,serverscript,filestreamclient,filestreamserver
Repeat this procedure for all WEB servers and application servers in the SharePoint farm.
confirm the RBS client library installation
The Rbs_install_log.txt log file is created in the same location as the Rbs_amd64.msi file. Please use a text editor to open the Rbs_install_log.txt log file and scroll to the bottom of the file. In the last 20 lines at the end of the file, there should be one item that says: "Product: SQL remote Blob Storage – Installation completed successfully".
On a computer that is running SQL Server 2008, verify that the RBS table is created in the content database. Some tables should be listed under the content database with the letter "Mssqlrbs" in front of the name.
enable RBS for each content database
You must enable RBS on a WEB server in a SharePoint farm. When performing this activity, it is not important to choose which Web server to use, as long as RBS is installed on that server using the procedure above. You must perform this procedure once for each content database.
Attention: |
You can only use Windows PowerShell to enable RBS. |
enable RBS using Windows PowerShell
-
Confirms that you meet the following minimum requirements: see add-spshelladmin.
-
To start the SharePoint 2013 Management Shell.
For more information about how to interact with Windows Server 2012, see Common management tasks and navigation in windows Server 2012.
-
At the Windows PowerShell command prompt, type the following command:
copy $cdb = Get-spcontentdatabase < Contentdatabasename> $RBSS = $cdb. Remoteblobstoragesettings$rbss. Installed () $rbss. Enable () $rbss. Setactiveprovidername ($RBSS. Getprovidernames () [0]) $RBSS
Where:
For more information, see Get-spcontentdatabase.
assigning db_owner permissions to a WEB application
Important NOTES: |
Ensure that the WEB application that accesses the RBS-enabled content database is a member of the db_owner fixed database role for the database. |
test the RBS installation
You should test the RBS installation on a WEB server in your SharePoint farm to ensure that the system is running correctly.
test the RBS data store
On the computer that contains the RBS data store, click Start, and then click Computer.
Browse to the RBS data store directory.
Confirm that the folder is empty.
In a SharePoint farm, upload files that are at least a few kilobytes (KB) to the document library.
On the computer that contains the RBS data store, click Start, and then click Computer.
Browse to the RBS data store directory.
Browse to the file list and open the file with the most recent modification date. This file should be the file you uploaded.
SharePoint 2013 uses the RBS feature to store binary large object blobs outside the content database.