locked
Remote Blob at Site collection level only? RRS feed

  • Question

  • I'm about to configure RBS on a Test server using this guide:

    http://technet.microsoft.com/en-us/library/ee748631.aspx#Section4

    Question:  We create a Site collection on it's own DB. Can I enable RBS for just that one site collection?

    I'm asking because this line in the guide:

    $cdb = Get-SPContentDatabase –WebApplication <http://SiteName>

    Where <http://SiteName> is the URL of the Web application that is connected to the content database.

    Implies I should only be setting in on the WebApplpication.. but what if my web application has multiple DBs? or I only want RBS for one fo the site collections and it's content DBs.

    Thanks.

     

    Thursday, February 24, 2011 7:51 PM

Answers

  • I was stuck at the same problem. After a week of install - uninstall, restarting the server, found out the culprit. I had two content databases for one web application. Looks like that was the problem. I removed the second content database (which was not set for rbs) and voila - all is well.

    I printed $cdb and in my case the result was

    Id               : 5484e197-746a-401d-acc3-4bd69b930ad7
    Name             : WSS_Content_d34ff7c6773a48aab1be7871d4136be3
    WebApplication   : SPWebApplication Name=SharePoint - 5620
    Server           : 01HW337265\SharePoint
    CurrentSiteCount : 1

    Id               : 203df705-1a68-4b95-9f5c-7176b34c351c
    Name             : WSS_Content_TestAdditionalDB
    WebApplication   : SPWebApplication Name=SharePoint - 5620
    Server           : 01HW337265\SharePoint
    CurrentSiteCount : 0

    I removed the second content database and performed the ps steps again.


    Veena
    • Proposed as answer by Cawood Monday, April 25, 2011 12:26 PM
    • Marked as answer by Waqas Sarwar(MVP) Tuesday, November 1, 2016 1:46 PM
    Monday, April 25, 2011 11:28 AM

All replies

  • you can use this method, in this way you " Set a content database to use Remote BLOB Storage (RBS) (SharePoint Server 2010)"

     

    http://technet.microsoft.com/en-us/library/ee748641.aspx

     

    hope this help

    thanks

    -ws


    SharePoint administrator, MCTS,MCITP
    Thursday, February 24, 2011 9:02 PM
  • Hi JCNET, you're right. Using the RBS provider shipped with SQL Server 2008 you can only work at Content Database level, but this doesn't mean that is web application level. You could enable RBS just for the site collection / content database you want to.

    Get-SPContentDatabase cmdlet's parameter -webapplication is not mandatory. You can also run $cdb = Get-SPContentDatabase "YOURDBNAME" and enable RBS just for one content db. Todd Klindt wrote a post about that: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?List=56f96349%2D3bb6%2D4087%2D94f4%2D7f95ff4ca81f&ID=174.

    Cheers
    Riccardo


    fino a quì tutto bene
    Thursday, February 24, 2011 9:20 PM
  • I think I followed steps, but don't see anything of size in my new blob volume.

    After I created a new site collection /sites/blobtest3 on a new content db DB. wss_content_blobtest3

    I performed this step:

    msiexec /qn /lvx* "C:\xxx\rbs3.txt" /i RBS_X64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="wss_Content_BlobTest3" DBINSTANCE="mydbinstance" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

    It came right back.

    got this log back .. which does not say successful:

    === Verbose logging started: 2/25/2011  12:44:33  Build type: SHIP UNICODE 5.00.7600.00  Calling process: C:\Windows\system32\msiexec.exe ===
    MSI (c) (BC:9C) [12:44:33:309]: Resetting cached policy values
    MSI (c) (BC:9C) [12:44:33:309]: Machine policy value 'Debug' is 0
    MSI (c) (BC:9C) [12:44:33:309]: ******* RunEngine:
               ******* Product: RBS_X64.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (BC:9C) [12:44:33:310]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (BC:9C) [12:44:33:322]: Grabbed execution mutex.
    MSI (c) (BC:9C) [12:44:33:354]: Cloaking enabled.
    MSI (c) (BC:9C) [12:44:33:354]: Attempting to enable all disabled privileges before calling Install on Server
    MSI (c) (BC:9C) [12:44:33:359]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (58:54) [12:44:33:381]: Running installation inside multi-package transaction C:\Windows\system32\RBS_X64.msi
    MSI (s) (58:54) [12:44:33:381]: Grabbed execution mutex.
    MSI (s) (58:9C) [12:44:33:400]: Resetting cached policy values
    MSI (s) (58:9C) [12:44:33:400]: Machine policy value 'Debug' is 0
    MSI (s) (58:9C) [12:44:33:400]: ******* RunEngine:
               ******* Product: C:\Windows\system32\RBS_X64.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (58:9C) [12:44:33:401]: Note: 1: 2203 2: C:\Windows\system32\RBS_X64.msi 3: -2147287038
    MSI (s) (58:9C) [12:44:33:401]: MainEngineThread is returning 2
    MSI (s) (58:54) [12:44:33:402]: User policy value 'DisableRollback' is 0
    MSI (s) (58:54) [12:44:33:402]: Machine policy value 'DisableRollback' is 0
    MSI (s) (58:54) [12:44:33:402]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (58:54) [12:44:33:402]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (58:54) [12:44:33:402]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (58:54) [12:44:33:402]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
    MSI (s) (58:54) [12:44:33:402]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
    MSI (s) (58:54) [12:44:33:402]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (s) (58:54) [12:44:33:403]: Restoring environment variables
    MSI (c) (BC:9C) [12:44:33:404]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (BC:9C) [12:44:33:404]: MainEngineThread is returning 2
    === Verbose logging stopped: 2/25/2011  12:44:33 ===

    not sure if this above is okay or not and not seeing anything in the event log I proceeded with the sql comands, which appear to be successful.

    use

     

    [WSS_Content_blobtest3]

    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_blobtest3]

    if

     

    not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')alter database [WSS_Content_blobtest3]

     

    add filegroup RBSFilestreamProvider contains filestream

     

    use

     

    [WSS_Content_blobtest2]

    alter

     

    database [WSS_Content_blobtest3] add file (name = RBSFilestreamFile, filename = 'f:\blobtest3') to filegroup RBSFilestreamProvider

     

    I logged into the new site collection and added a bunch of files to a library, but did not see any change in my new F:\blobtest3 volume.

    I only see a folder $FSLOG and a file fielstream.hdr

    Not sure if it matters, but my drive volume is Network Storage.  I'm running a fresh sp2010 install under 2008 R2 Sever and Sql 2008. Patched up all the way.

     

    Many Thanks.

     

     

    Update: this is what I gett when I run the shell commands:

    $rbss.Installed()

    I get False.

    I reinstalled RBS (no errors/no events) and reconfirmed FileStream is enabled on my instances.

    Ran the commands again that produced false, and it still says false.

    My version of SQL 2008 does not say R2 when I look at it from Start menu..

    ...

    UPDATE:

    Went through the process again:

    Same log information. same result:

    PS C:\Users\spsvc> $cdb = Get-SPContentDatabase wss_content_blobtest4
    PS C:\Users\spsvc> $rbss = $cdb.RemoteBlobStorageSettings
    PS C:\Users\spsvc> $rbss.Installed()
    False
    PS C:\Users\spsvc> $rbss.Enable()
    Exception calling "Enable" with "0" argument(s): "SQL remote blob storage must
    be installed on each web front end server and on the content database before it
     may be used."
    At line:1 char:13
    + $rbss.Enable <<<< ()
        + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
        + FullyQualifiedErrorId : DotNetMethodException

    PS C:\Users\spsvc>

     

    • Edited by o365spo Friday, February 25, 2011 9:26 PM
    Friday, February 25, 2011 8:58 PM
  • If you get $rbss.Installed() returned as false then nothing else will work.  At first glance i did not see anything incorrect in your scripts.  Try to run the MSI manually and step through the wizard and provide those values manually.  I had this same thing happen a couple times in my test environments.
    Friday, February 25, 2011 9:14 PM
  • Thanks.

    Not sure what you mean by step through the wizard? Are there RBS related steps in the SP Config Wizard?

    BTW, when I supplied the Filestream Share Name, do I need to enter that anywhere in any of these steps. It automtically selected MSSQLSERVER I think.

    I'm going to reboot. :)

     

    Friday, February 25, 2011 9:30 PM
  • No, you don't need to run the conf. wizard again. What kind of network storage are connected to? I remember that with the default provider there are several limitations in terms of remote storage.

    Cheers
    Riccardo


    fino a quì tutto bene
    Friday, February 25, 2011 9:38 PM
  • i meant run the msi manually dont use command line. Then you can step through the setup wizard.  As to the filestream no not the acual dir name, that gets created when you run the filestream setup, then you provide the group name in the RBS setup wizard and that should be good.
    Friday, February 25, 2011 9:38 PM
  • @Chris Geier I don't think that run msi manually is a good idea, I never read about that. Do you have any good experience with that?

    @JCNET Did you run the cmd as administrator when you execute the msi setup?

    Cheers
    Riccardo


    fino a quì tutto bene
    Friday, February 25, 2011 9:44 PM
  • Yes I did run CMD and SP power shell as administrator.

    I just deinstalled RBS, and attempted to reinstall and when I attempt to test the connection to the DB it says the login failed. But in this test environment the only servcie account I'm using is an AD account that both the sp farm admin and the account connecting to the DB. It has full rights to the DB. The error says it cannot opent the remoteblobStorage database, but I see no such Database and there are no other instances on the server. Both SharePoint and SQL 2008 are on that same server.

    I would try as SA, but can't remember the SA password from this fresh install.

     UPDATE:

    I just changed SA password and retired to test a connection with it, and it gives me the same error.

    Perhaps I'm misunderstanding this install.. should I be entering an existing Database name on the RBS install? Right now it says RemoteBlobStorage which does not exist on my instance. Filegropu for internal tables says default. ?? I figured I would only be installing RBS (the product) once, and then preforming the prior steps for every new content db

    Friday, February 25, 2011 9:54 PM
  • Okay. sorry about all of this..

    Do I need to run the RBS install wizard for every Databse that will use RBS. And I still need to do all of the above steps?

    I just did that and of course connnection worked.. duh.. , but at end of install  I got

    Access to registry Key Remote blob Storage is denied. Setup will continue my installation.

     

    Friday, February 25, 2011 10:08 PM
  •  I figured I would only be installing RBS (the product) once, and then preforming the prior steps for every new content db

    No, you have to run setup for every content database that has to be RBS enabled, because is the msi setup that you set where you want to enable it (and many other things).

    It's hard to say what's the cause of your error (remoteblobstorage database), can you add more details?

    Cheers
    Riccardo

     


    fino a quì tutto bene
    Friday, February 25, 2011 10:10 PM
  • And I still need to do all of the above steps?


    Yes, since you set the store location with SQL script and you enable content database to use RBS with powershell by SharePoint side.

    (I'm sorry for the answer above I think that we co-posted :))

    Cheers
    Riccardo


    fino a quì tutto bene
    Friday, February 25, 2011 10:14 PM
  • Something does not add up. If I run the RBS Windows Installer Package again - it now prompt me to modify.  Am I define the one database to be used by RBS for all the databases I will enable RBS on? Do I have to create that Database First?

    Remoteblobstorage database is the name of a db that the install placed in the entry by default. that DB is not mine.  I entered the DB I wanted RBS for and the install progressed.

    As for the registry error now, I don't even see the HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\REMOTE BLOB STORAGE entry the setup  says it does not have access to.

    Thanks.

    • Edited by o365spo Friday, February 25, 2011 10:25 PM
    Friday, February 25, 2011 10:17 PM
  • did you run RBS_X464.msi manually?
    fino a quì tutto bene
    Friday, February 25, 2011 10:24 PM
  • at some point yes.

    msiexec /qn /lvx* "C:\xxx\rbs3.txt" /i RBS_X64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="wss_Content_BlobTest3" DBINSTANCE="mydbinstance" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

    But wasn't the first step to  install RBS first by running RBS.msi after I download it. Until I do that RBS_X464.msi is not available in the windows path right?

    I clicked on RBS.msi and de-installed everything both RBS and Filestream.  Isn't my first step to download RBS.msi and run (click on) it. If so, what database do I enter in that wizard and will I need to perform that step again.  what's confusing is it's pointing to DB that does not exist.  that appears to be a step you perform once, not for every db you enable RBS for.

    Friday, February 25, 2011 10:32 PM
  • If by Manually you mean the msiexec step. Otherwise No. When I fisrt download the RBX x64 file I get a RBS.msi file. I am installing that and getting a wizard that seems to point to a database that does not exsist.  What I am asking, If I have multiple Databases that will have RBS enabled, what database should I use in that install step? and will I be running (clicking on) rbs.msi again?
    Friday, February 25, 2011 10:43 PM
  • I think that the only way to mak RBS works is to run RBS_x64.msi using msiexec. I didn't ever heard about configuring RBS by clicking on the setup file. If you have to enable RBS on more then one content database you have to follow the whole procedure for each content database: T-SQL script, msiexec, Powershell (see Todd Klindt post linked above).

    Cheers
    Riccardo


    fino a quì tutto bene
    Friday, February 25, 2011 10:50 PM
  • I was stuck at the same problem. After a week of install - uninstall, restarting the server, found out the culprit. I had two content databases for one web application. Looks like that was the problem. I removed the second content database (which was not set for rbs) and voila - all is well.

    I printed $cdb and in my case the result was

    Id               : 5484e197-746a-401d-acc3-4bd69b930ad7
    Name             : WSS_Content_d34ff7c6773a48aab1be7871d4136be3
    WebApplication   : SPWebApplication Name=SharePoint - 5620
    Server           : 01HW337265\SharePoint
    CurrentSiteCount : 1

    Id               : 203df705-1a68-4b95-9f5c-7176b34c351c
    Name             : WSS_Content_TestAdditionalDB
    WebApplication   : SPWebApplication Name=SharePoint - 5620
    Server           : 01HW337265\SharePoint
    CurrentSiteCount : 0

    I removed the second content database and performed the ps steps again.


    Veena
    • Proposed as answer by Cawood Monday, April 25, 2011 12:26 PM
    • Marked as answer by Waqas Sarwar(MVP) Tuesday, November 1, 2016 1:46 PM
    Monday, April 25, 2011 11:28 AM