Remote BLOB Storage

RBS and SharePoint 2010

Enable FILESTREAM

1. Start SQL Server Configuration Manager.

2. Click SQL Server Services.

3. Right-click SQL Server (MSSQLServer), and then click Properties.

4. Click the FILESTREAM tab.

5. Select the Enable FILESTREAM for Transact-SQL access check box.

6. Select the Enable FILESTREAM for file I/O streaming access check box.

7. Select the Allow remote clients to have streaming access to FILESTREAM

data check box.

8. Click OK.

Configure FILESTREAM Access Level

1. Start SQL Server Management Studio.

2. In Object Explorer, right-click the SQL Server, and then click Properties.

3. In the Select a page section, click Advanced.

4. Click Filestream Access Level, click the drop-down arrow, click Full access

enabled, and then click OK.

A message appears indicating that you must restart SQL Server.

5. In Object Explorer, right-click the computer running SQL Server, and then

click Restart.

A confirmation dialog appears.

6. Click Yes.

Provision a BLOB Store

The next step is to provision the BLOB store that, in this case, is a folder on a local

Storage volume, for example, F:\Blobstore.

IMPORTANT: Do not create the folder by using Windows Explorer. Use the

Following procedure, and SQL Server will create the folder automatically.

1. Start SQL Server Management Studio.

2. Select the content database for which you want to provision a BLOB store, and

then click the New Query button on the toolbar.

The Query Editor opens a new query in the details pane.

3. To set the database master key, type the following query into the Query Editor:

Repeat the following Statements for two DBs

 

use [ContentDBName]

if not exists (select * from sys.symmetric_keys where name =

N’##MS_DatabaseMasterKey##’)create master key encryption by

password = N’EncryptionKeyPassword‘

Where:

• ContentDBName Wss_content_intranet and wss_content_siteservices

• EncryptionKeyPassword content-siteservices

4. Click the Execute button in the toolbar.

5. Click the New Query button on the toolbar.

The Query Editor opens a new query in the details pane.

6. To enable a new filegroup for your RBS provider, type the following query into

the Query Editor:

use [ContentDBName]

if not exists (select groupname from sysfilegroups where

groupname=N’RBSFilestreamProvider’)alter database [ContentDBName]

add filegroup RBSFilestreamProvider contains filestream

Where:

• ContentDBName Wss_content_intranet and wss_content_siteservices

BLOB Store will be provisioned.

7. Click the Execute button in the toolbar.

8. Click the New Query button on the toolbar.

The Query Editor opens a new query in the details pane.

9. To add a file system mapping for your RBS provider, type the following query

into the Query Editor:

use [ContentDBName]

alter database [ContentDBName] add file (name = RBSFilestreamFile,

filename = ‘BlobStorePath‘) to filegroup RBSFilestreamProvider

Where:

• ContentDBName Wss_content_intranet and wss_content_siteservices BLOB Store will be provisioned.

• BlobStorePath is the path to the BLOB store folder you want to create, for

example, F:\Blobstore. For best performance, simplified troubleshooting,

and as a general best practice, you should create the BLOB store on a

volume that does not contain the operating system, paging files, database

data, log files, or the Tempdb file.

10. Click the Execute button on the toolbar.

Repeat the procedure for each content database for which RBS should be

provisioned.

Install RBS on a Front-End Server

User the Sharepoint powershell

msiexec /qn /lvx* <InstallLogFile> /i RBS.msi

TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY

DBNAME=”<ContentDbName>” DBINSTANCE=”<DBInstanceName>”

FILESTREAMFILEGROUP=RBSFilestreamProvider

FILESTREAMSTORENAME=FilestreamProvider_1

 

Where:

• InstallLogFile is the name and optional path of a log file that will be

generated by the installation, for example, rbs_install_log.txt.

ContentDBName Wss_content_intranet and wss_content_siteservices BLOB Store will be provisioned

• DBInstanceName is the server and instance name of SQL Server.

Confirm RBS Installation

You can confirm the installation of RBS by examining the content database for

tables that begin with mssqlrbs. You can use the following query to determine

whether the tables exist:

USE [ContentDBName]

SELECT * from dbo.sysobjects

WHERE name like ‘mssqlrbs%’

Enable RBS Using Windows Power Shell

You must enable RBS on one Web server in the SharePoint farm. It does not matter

Which Web server you choose for this activity, as long as RBS was installed on it by

Using the previous procedure.

In SharePoint 2010 Management Shell, type the following commands:

$cdb = Get-SPContentDatabase “<ContentDBName>”

$rbss = $cdb.RemoteBlobStorageSettings

$rbss.Installed()

$rbss.Enable()

$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])

$rbss

Configure BLOB Size Threshold Using Windows PowerShell

You can configure the BLOB size threshold above which BLOBs are stored in the

RBS provider. If a BLOB is below the threshold, it is stored in the SQL Server

database.

In SharePoint 2010 Management Shell, type the following commands:

$cdb = Get-SPContentDatabase “<ContentDBName>”

$rbss = $cdb.RemoteBlobStorageSettings

$rbss.MinimumBlobStorageSize = 1048576

$cdb.update()

Security Planning For Sites and contents

Create Global security group on SharePoint for all users with view permissions

For every site create 2 group one with read only other with edit

And group for Engineering for view all contents under Engineering

This group is an AD group and it is already created

Name will be EX: Electrical-Read and electrical-edit