SharePoint 2013 uses the RBS feature to store binary large object blobs outside the content database.

Source: Internet
Author: User
Tags filegroup microsoft sql server management studio sql server management sql server management studio

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
  1. 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.

  2. Click Start, All Programs, Microsoft SQL Server 2008, and then SQL Server Management Studio.

  3. Connect to the instance of SQL Server that hosts the content database.

  4. Expand Databases.

  5. Click the content database for which you want to create BLOB storage, and then click New Query.

  6. 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
    1. 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.

    2. On any WEB server, browse to http://go.microsoft.com/fwlink/p/?LinkId=271938 and download the Rbs_amd64.msi file.

    3. Click Start, click Run, type cmdin the Run text box, and then click OK.

    4. 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.

      Copy
      msiexec/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
    1. 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.

    2. On any WEB server, browse to http://go.microsoft.com/fwlink/p/?LinkId=271938 and download the Rbs_amd64.msi file.

    3. Click Start, click Run, type cmdin the Run text box, and then click OK.

    4. 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.

      Copy
      msiexec/qn/lvx* rbs_install_log.txt/i rbs_amd64.msi dbname= "wss_content" dbinstance= "DBInstanceName" ADDLOCAL= Client,docs,maintainer,serverscript,filestreamclient,filestreamserver
    5. Repeat this procedure for all WEB servers and application servers in the SharePoint farm.

confirm the RBS client library installation
    1. 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".

    2. 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
    1. Confirms that you meet the following minimum requirements: see  add-spshelladmin.

    2. To start the SharePoint 2013 Management Shell.

      • For Windows server 2008 r2:

        • On the Start menu, click All Programs, click Microsoft Sharepo Int 2013 products, and then click SharePoint 2013 Management Shell.

      • For Windows Server:

        1. On the Start menu, click SharePoint 2013 Management Shell.

          If the SharePoint 2013 Management Shell does not appear on the Start \ screen, then:

        2. Right-click Computers, click All applications, and then click 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.

    3. 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:

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

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
    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. In a SharePoint farm, upload files that are at least a few kilobytes (KB) to the 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 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.