to config RBS/RBLOB in sharepoint
http://technet.microsoft.com/en-us/library/gg316768(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/gg316737(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/ee663474(v=office.14).aspx#provision most valuable
scripts:
1.
using the command to install rbs for fore front server, note the msiexec /n , it's different from the user guide
msiexec /n /lvx* rbs_install_log.txt /i RBS.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content_80" DBINSTANCE="MSSQLSERVER" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1
2.
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'
go
if not exists
(select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
alter database [WSS_Content_80] add filegroup RBSFilestreamProvider contains filestream
go
alter database [WSS_Content_80] add file (name = RBSFilestreamFile, filename = 'd:\Blobstore_80') to filegroup RBSFilestreamProvider
go
3.
$cdb = Get-SPContentDatabase WSS_Content_80
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
$rbss
4. to reduce the file from disk while a file is deleted from document library
http://blog.bugrapostaci.com/2013/01/05/unable-to-delete-rbs-blob-data-from-file-system-even-deleting-from-sharepoint-2010/
http://blogs.msdn.com/b/sqlrbs/archive/2010/03/19/running-rbs-maintainer.aspx
Microsoft.Data.SqlRemoteBlobs.Maintainer.exe -ConnectionStringName RBSMaintainerConnection -Operation GarbageCollection ConsistencyCheck -GarbageCollectionPhases rdo -ConsistencyCheckMode r
最新文章
- 电商CRM的痛点在哪里?
- ARM-Linux S5PV210 UART驱动(3)----串口核心层、关键结构体、接口关系
- hadoop之JobTracker功能分析
- thbgm拆包【in progress】
- nodejs 包引用的终极结论
- LeetCode算法题-Can Place Flowers(Java实现)
- React16.x特性剪辑
- Eclipse环境搭建并且运行wordcount程序
- 安装UEStudio以及破解
- maven ${path.separator}
- CSS 3D transforms
- E. Train Hard, Win Easy
- hadoop MapReduce —— 输出每个单词所对应的文件
- 通过DOS命令批量重命名文件
- django 不能访问静态资源的解决办法
- CentOS扩展库配置
- scala编程第18章学习笔记——有状态的对象
- 如何把连接字符串放到App.cfg配置文件中
- mathematical method
- Mysql--产品支持的平台