Skip to main content

How to configure the Remote BLOB Storage(RBS) on Sharepoint Web application


Remote BLOB Storage (RBS) is an add-on feature pack for Microsoft SQL Server 2008. RBS is designed to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. If the content databases in Microsoft SharePoint Server 2010 are 4 gigabytes (GB) or larger, consider using RBS as part of your data storage solution.
We are able to enable the RBS ( Remote blob storage) for the SharePoint.

How to enable RBS on SharePoint web application.

Server Instance level settings.

1.       Open SQL configuration tool-> Start-> All Programs-> Microsoft SQL Server 2008 R2-> Configuration Too-> SQL Server Configuration Manager

In the SQL Server Configuration Manager snap right click on the SQL instance where you want to enable FILE STREAM.


1.       Click on Properties and select FILE STREAM tab


Select all check boxes and press ok.


Database level configuration.

1.       Open the Query windows from the SQL and execute following query.

EXEC sp_configure filestream_access_level, 2
    RECONFIGURE
==========================
2.       Now go the SQL server and select the content database on which we need to enable RBS. Eg. Suppose we have a web application and the content database for this web application is WSS_Conten_8000 then open the query windows of WSS_Content_800 database.

Execute following Queries


use [WSS_Content_8000] --- name of the content databaes
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_8000]
if not exists
(select groupname from sysfilegroups
where groupname=N'RBSFilestreamProvider')
alter database [WSS_Content_8000]
add filegroup RBSFilestreamProvider contains filestream

use [WSS_Content_8000]
alter database [WSS_Content_8000]
 add file (name = RBSFilestreamFile, filename =
'D:\Blobstore')
to filegroup RBSFilestreamProvider
===============================
The last command will create a folder in your D: name Blogstore. This is the folder where SharePoint will store the files.

Install the RBS client library on each Web server
1.     Download setup from http://go.microsoft.com/fwlink/p/?LinkID=165839&clcid=0x409 to local drive on the SQL server
2.     Open command prompt and run following command

msiexec /qn /lvx* rbs_install_log.txt /i RBS_x64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content_8000" DBINSTANCE="VIN-048\SHAREPOINT" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

NOTE: in above command change parameter for  DBNAME and DBINSTANCE parameter

Validate that client library install correctly.

1.    Open  content database , there will be many new tables start with mssqlrbs.. . See below image.


Enable RBS at content database level.

1.       Open powershell and run following command
------------------------------
$cdb = Get-SPContentDatabase WSS_Content_8000
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
$rbss

Testing of the application

2.       Upload documents in the document library. At SharePoint level you will not see any difference but you can check the Blogstorage folder.




Reference Link:












Comments

Post a Comment

Popular posts from this blog

Tab Control in Asp.Net

Scenerio: I need your help in designing tab control in   asp.net .My requirement is I need a tab control in   asp.net (C#) like  for example goto my computer ,right click c drive and select properties.we get tabs like general,security etc....... like that i need to design one tab control(no need of any rightclick) in my web page and the database table columns should come as tabs and inseide the tab data of that particular column should come.   Example:Employee master tab1:Employee name.........his name in the tab tab2:Age.............his age tab3:Address........his address   Solution:   You can do this using a simple div <style type="text/css"> .tabs         {             position: relative;             height: 20px;             margin: 0;   ...
Post a Comment
Read more

AI and Microsoft: Revolutionizing Efficiency in Nonprofit Organizations

  How AI and Microsoft Enhance Efficiency in Nonprofit Organizations In today’s fast-paced world, nonprofit organizations face unique challenges—limited resources, increasing demands, and the constant need to do more with less. But what if technology could be the game-changer they need? In my latest research paper,  "How AI and Microsoft Enhance Efficiency in Nonprofit Organizations" , I explore how cutting-edge technologies like Artificial Intelligence (AI) and Microsoft’s innovative tools are revolutionizing the way nonprofits operate. From streamlining administrative tasks to enhancing donor engagement and optimizing resource allocation, AI and Microsoft’s solutions are empowering nonprofits to focus on what truly matters—their mission. This paper dives deep into real-world examples, practical applications, and the transformative potential of these technologies. Whether you’re a nonprofit professional, a tech enthusiast, or simply curious about the intersection of technolo...
Post a Comment
Read more

Social tagging overview in Sharepoint 2010

A tag is a word or phrase that identifies an individual piece of information according to a set of attributes or criteria. Tags make it easy to find and share information about a specific subject or task. Social tagging helps users categorize information in ways that are meaningful to them. Social tagging can improve the quality of search results by filtering against specific tags, and it can also connect individuals who want to share information with other users who have like interests. This article describes the social tagging features in Microsoft SharePoint Server 2010. This article does not describe how to configure social tagging features. It also does not discuss how to implement social tagging features as part of an overall social media strategy for an enterprise. About using social tagging features Social tagging features help users to share information and to retrieve relevant, high-quality content more efficiently. Such sharing encourages collaboration and b...
295 comments
Read more