Remote BLOB Storage

Nathan DeWitthttp://nathandewitt.net/

WHAT’S A BLOB?

Blob: Super Villain

BLOB: Binary Large Object

Pictures

Large Documents

HOW DO WE STORE LARGE FILES?

In the database

WHY IS THAT BAD?

Big files take longer to retrieve

Requests stack up

Web server pages slow down

Bye-bye, uptime.

Website is not accessible. Please try back later.

IS THERE A BETTER WAY?

SQL Server 2008FILESTREAM data type

HOW DO I DO THIS IN SHAREPOINT?

Provision a Data Store!

use [Content_DB]if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')create master key encryption by password = N'Master Key Pa$$w0rd'

if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')alter database [Content_DB]add filegroup RBSFilestreamProvider contains filestream alter database [Content_DB] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroup RBSFilestreamProvider 

Install RBS!

PS C:\> msiexec /qn /lvx* rbs_install_log1.txt /i RBS.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="Content_DB" DBINSTANCE="SERVERNAME" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=RBSFilestreamStore

 

Enable RBS for a Content Database!

PS C:\> $cdb = Get-SPContentDatabase "Content_DB"

PS C:\> $rbss = $cdb.RemoteBlobStorageSettings

PS C:\> $rbss.Installed()PS C:\> $rbss.Enable()PS C:\> $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])

PS C:\> $rbss

DocumentLibrary

File System

items uploaded to the

are actually stored in the

Verify!

Profit!

 Any questions?