停用 SharePoint Server 內容資料庫上的 RBSDisable RBS on content databases in SharePoint Server

摘要:了解如何在任何 SharePoint Server 2016 和 SharePoint 2013 內容資料庫上停用遠端 BLOB 儲存 (RBS)。Summary: Learn how to disable Remote BLOB Storage (RBS) on any SharePoint Server 2016 and SharePoint 2013 content database.

您可以在任何內容資料庫上停用遠端 BLOB 儲存 (RBS)。在內容資料庫上停用 RBS 之後,二進位大型物件 (BLOB) 將會內嵌至 SQL Server 中,以便於後續寫入至內容資料庫。本文說明如何在內容資料庫上停用 RBS。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.

在 Microsoft PowerShell 中,透過設定作用中的提供者名稱為空字串,您可以停用內容資料庫上的 RBS。每個內容資料庫都具備一個可用於叫用 SetActiveProviderName 方法的 RemoteBlobStorageSettings 屬性。You can disable RBS on a content database by setting the active provider name to the empty string in Microsoft PowerShell. Each content database has a RemoteBlobStorageSettings property that can be used to invoke the SetActiveProviderName method.

此動作不會變更先前已儲存在 RBS 中,或內置儲存區中的任何 RBS 儲存位置。停用 RBS 不會導致解除安裝 RBS。不建議您解除安裝 RBS。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.

開始這項作業之前,請先檢閱下列先決條件的相關資訊:Before you begin this operation, review the following information about prerequisites:

停用內容資料庫的 RBSDisable RBS for a content database

在伺服器陣列中任何的網頁伺服器上都可以執行此作業。您只需要在一部 Web 伺服器上針對要停用 RBS 的每個內容資料庫執行一次該作業。This operation can be performed on any Web server in the farm. You only have to perform the operation one time on one Web server for each content database for which you want to disable RBS.

警告

[!注意] 請勿在 RemoteBlobStorageSettings 物件上使用 Disable() 方法。此方法只用於解除安裝 RBS,且不建議您只停用新 BLOB 寫入至 RBS。Do not use the Disable() method on the RemoteBlobStorageSettings object. This method is used only to uninstall RBS, and we do not recommend that you just disable the writing of new BLOBs into RBS.

您必須使用 Microsoft PowerShell Cmdlet 才能停用 RBS。此工作沒有任何使用者介面選項。You must use Microsoft PowerShell cmdlets to disable RBS. There is no user interface option for this task.

使用 PowerShell 停用 RBSTo disable RBS by using PowerShell

  1. 確認您具備下列成員身分:Verify that you have the following memberships:

    • SQL Server 執行個體上的 securityadmin 固定伺服器角色。securityadmin fixed server role on the SQL Server instance.

    • 所有要更新之資料庫上的 db_owner 固定資料庫角色。db_owner fixed database role on all databases that are to be updated.

    • 正在執行 PowerShell Cmdlet 之所在伺服器上的系統管理員群組。Administrators group on the server on which you are running the PowerShell cmdlets.

  2. 啟動 SharePoint 管理命令介面。Start the SharePoint Management Shell.

  3. 在 PowerShell 命令提示字元處輸入下列命令:At the PowerShell command prompt, type the following commands:

    $site=Get-SPSite "<http://yourSiteURL>"
    $rbss=$site.ContentDatabase.RemoteBlobStorageSettings
    $rbss.SetActiveProviderName("")
    

    其中 <http://yourSiteURL> 是附加至 RBS 已停用內容資料庫的 Web 應用程式。Where <http://yourSiteURL> is the Web application that is attached to the content database that is being disabled for RBS.

    如需詳細資訊,請參閱<Get-SPSite>。For more information, see Get-SPSite.

另請參閱See also

概念Concepts

在 SharePoint Server 中利用 FILESTREAM 設定內容資料庫以使用 RBSSet a content database to use RBS with FILESTREAM in SharePoint Server