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
