Moving content back to Content DB

Mar 3, 2011 at 9:16 PM

Hello,

As for background;

  1. I've installed RBS.msi as per this article http://technet.microsoft.com/en-us/library/ff628969.aspx
  2. Compiled FileStoreProvider
  3. Gather all required files as in Script folder, and FileStoreProvider.dll
  4. Register FileStoreProvider.dll into GAC
  5. Ran following PowerShell command
    $cdb = Get-SPContentDatabase -WebApplication http://siteurl
    $rbss=$cdb.RemoteBlobStorageSettings
    $rbss.Installed()
    $rbss.Enable()
    $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
    Then I added a document in one of the document library, I could see that document was being created in storage location and RBSID in allDocStreams
  6. Everything went fine! :-)
  7. I ran $rbss.Migrate() to migrate all documents into storage location. I could see RBSID and Null in Conent filed of allDocSteams table 
  8. Then i wanted to disable RBS provider and move contents back to db. For this I ran following powershell command
    
  9. I thought this should move all the contents back to content db, but I am not sure what is the problem this is not happening to me. I can still see null in content field and RBSID as it was.
    Everytime I perform step-8, I see following error message in Event Viewer

Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below.

Procedure or function 'proc_SetDatabaseInformation' expects parameter '@Value', which was not supplied.

 

 

 Could somebody point me what am I missing here?

Thanks in advance for your help.

Suman Pradhan
http://www.sumanpradhan.com

 

Apr 10, 2011 at 6:38 PM

Shouldn't it be:

 

$cdb = Get-SPContentDatabase -WebApplication http://mysitenurl
$rbss=$cdb.RemoteBlobStorageSettings
$rbss.Disable()
$rbss.SetActiveProvideName("")