Thursday, February 23, 2017

RBS enable for sharepoint second content DB

1. add pool account to the dbowner content database


2.run sql script crease RBS group

USE WSS_Content_RBS
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_RBS
if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
alter database WSS_Content_RBS add filegroup RBSFilestreamProvider contains filestream

USE WSS_Content_RBS
alter database WSS_Content_RBS add file (name = RBSFilestreamFile, filename = 'F:\WSS_Content_staffhub_RBS_test') to filegroup RBSFilestreamProvider

 3.check blob folder created

4. Run at DB server for second content db

msiexec /lvx* WSS_Content_RBS.txt /i rbs.msi REMOTEBLOBENABLE=1 FILESTREAMPROVIDERENABLE=1 FILEGROUP=PRIMARY FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FileStreamProvider_1 ADDLOCAL=EnableRBS,FilestreamRunScript DBINSTANCE=

*use interface to setup
  
6.check will see rbs table

7.run powershell

$cdb = Get-SPContentDatabase WSS_Content_RBS
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])  #make sure is only one provider 
$rbss



8.upload file and check on RBS folder