Disable RBS on a content database (SharePoint Foundation 2010)
Applies to: SharePoint Foundation 2010
You can disable Remote BLOB Storage (RBS) on any content database. After you disable RBS on a content database, binary large objects (BLOBs) are stored inline in SQL Server for all subsequent writes to the content database. This article describes how to disable RBS on a content database.
You can disable RBS on a content database by setting the active provider name to the empty string in Windows PowerShell. Each content database has a RemoteBlobStorageSettings property that can be used to invoke the SetActiveProviderName method.
This action does not change the storage location of any BLOBs that have previously been stored in RBS or inline storage. Disabling RBS does not uninstall RBS. We do not recommend that you uninstall RBS.
This operation can be performed on any Web server in the farm. You only need to perform the operation one time on one Web server for each content database for which you want to disable RBS.
Warning
Do not use the Disable() method on the RemoteBlobStorageSettings object. This method is used only to uninstall RBS, and it is not recommended to simply disable the writing of new BLOBs into RBS.
You must use Windows PowerShell 2.0 cmdlets to disable RBS. There is no user interface option for this task.
To disable RBS by using Windows PowerShell
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
At the Windows PowerShell command prompt, type the following commands:
$site=Get-SPSite "<http://yourSiteURL>" $rbss=$site.ContentDatabase.RemoteBlobStorageSettings $rbss.SetActiveProviderName("")
Where <http://yourSiteURL> is the Web application that is attached to the content database that is being disabled for RBS.
For more information, see Get-SPSite.