RBS Relationship?

Oct 8, 2013 at 5:25 PM
Edited Oct 8, 2013 at 5:28 PM
I have RBS installed and working with SQL Server 2012 and SharePoint 2013. I noticed that when using RBS it breaks the file into "chucks" (which it's supposed to do). I was wondering what the relationship was to these new files in the BLOB Store and the content database table. Is there anyway to identify which files in the BLOB Store are associated to the content database?

Does that even make any sense?
Oct 8, 2013 at 7:08 PM
The files are linked together internally and contain a lot of cobalt data.

iirc the alldocs (formerly alldocstreams in SP2010) table contains the RBSID, which depending on the RBS provider you have could be human readable after running it through a hex to ascii conversion - http://www.asciitohex.com/

mind if I ask which version of the RBS.msi you got working and what the parameters to msiexec you used were? I have this working, but I'm trying to figure out a better way.
Oct 8, 2013 at 9:23 PM
Edited Oct 8, 2013 at 9:25 PM
daemonoid wrote:
The files are linked together internally and contain a lot of cobalt data.

iirc the alldocs (formerly alldocstreams in SP2010) table contains the RBSID, which depending on the RBS provider you have could be human readable after running it through a hex to ascii conversion - http://www.asciitohex.com/

mind if I ask which version of the RBS.msi you got working and what the parameters to msiexec you used were? I have this working, but I'm trying to figure out a better way.
I don't see an RbsId column in AllDocs... I do see RbsId in the DocStreams table but every item is showing as NULL for RbsId.

I am using RBS_amd64.msi. The parameters I am using are:
msiexec /qn /lvx* "C:\Users\...\Desktop\RBS\Install_Log_Test.txt" /i RBS_amd64.msi DBNAME=Test DBINSTANCE=SHAREPOINT ADDLOCAL="EnableRBS,FilestreamRunScript"
Those parameters are used because I have setup more than one content database with RBS.