此伺服器陣列內的資料庫已設為唯讀,除非設為讀寫狀態,否則將無法升級 (SharePoint Server)Databases within this farm are set to read only and will fail to upgrade unless it is set to a read-write state (SharePoint Server)

摘要:了解如何解決 SharePoint Server 2016 和 SharePoint 2013 中的 SharePoint Health Analyzer 規則「伺服器陣列中的資料庫設為唯讀而將無法升級,必須設為可讀寫狀態才能升級」。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Databases within this farm are set to read only and will fail to upgrade unless it is set to a read-write state" in SharePoint Server 2016 and SharePoint 2013.

規則名稱:伺服器陣列中的資料庫設為唯讀而將無法升級,必須設為可讀寫狀態才能升級。Rule Name: Databases within this farm are set to read only and will fail to upgrade unless it is set to a read-write state.

摘要:資料庫已設為唯讀,無法升級。Summary: The databases are set to read-only and cannot be upgraded.

原因:資料庫已設為唯讀。Cause: The databases are set to read-only.

解決方案:使用 SQL Server 將資料庫設為讀寫。Resolution: Set the databases to read-write using SQL Server.

  1. 確認執行此程序的使用者帳戶為每個資料庫之 db_owner 固定資料庫角色的成員。Verify that the user account that is performing this procedure is a member of the db_owner fixed database role in each database.

  2. 啟動 SQL Server Management Studio。Start SQL Server Management Studio.

  3. 以滑鼠右鍵按一下要成為唯讀的內容資料庫並再按一下 [內容Right-click the content database that you want to make read-only, and then click Properties.

  4. 選取 [選項] 頁面上,並在 [其他選項] 清單中,捲動至 [狀態] 區段。Select the Options page, and, in the Other options list, scroll to the State section.

  5. 在 [資料庫唯讀] 列中,按一下 [ True] 旁的箭號、 選取為 False,並再按一下 [確定]In the Database Read-Only row, click the arrow next to True, select False, and then click OK.

  6. 對所有其他內容資料庫重複此程序。Repeat for all other content databases.

    注意

    [!附註] 在設定資料庫為唯讀後,將會停止所有連線 (但設定唯讀標幟的連線除外)。設定了唯讀標幟後,將會啟用其他連線。When a database is set to read-only, all connections except the one that is setting the read-only flag are stopped. After the read-only flag is set, other connections are enabled.