Set-SPContentDatabase

設定 SharePoint 內容資料庫的全域屬性。

Syntax

Set-SPContentDatabase
   [-Identity] <SPContentDatabasePipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-Confirm]
   [-MaxSiteCount <Int32>]
   [-Status <SPObjectStatus>]
   [-WarningSiteCount <Int32>]
   [-WhatIf]
   [-DatabaseFailoverServer <String>]
   [<CommonParameters>]

Description

Set-SPContentDatabase Cmdlet 會設定 SharePoint 內容資料庫的全域屬性。

如需適用於 SharePoint 產品的 Windows PowerShell 權限及最新資訊,請參閱線上文件 SharePoint Server Cmdlet

範例

---------------範例 1---------------

Get-SPContentDatabase https://contoso.com | Set-SPContentDatabase -MaxSiteCount 1

本範例會將包含 contoso.com 之內容資料庫的 MaxSiteCount 設定為 1。

---------------範例 2---------------

Get-SPContentDatabase -WebApplication https://sitename | Set-SPContentDatabase -WarningSiteCount $null

本範例會清除 Sitename Web 應用程式中所有資料庫的 WarningSiteCount。

參數

-AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:SPAssignmentCollection
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-Confirm

在執行命令之前,提示您確認操作。 如需詳細資訊,請輸入下列命令:get-help about_commonparameters

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-DatabaseFailoverServer

指定可供容錯移轉的鏡像伺服器名稱。

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-Identity

指定要更新的內容資料庫。

此類型必須是格式為 12345678-90ab-cdef-1234-567890bcdefgh 的有效 GUID;有效的 SharePoint 內容資料庫名稱 (例如 SPContentDB1);或有效之 SPContentDatabase 物件的執行個體。

Type:SPContentDatabasePipeBind
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-MaxSiteCount

指定此資料庫可控管的網站集合數目上限。

此類型必須是正整數。 若設定 $null,可清除此值。

Type:Int32
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-Status

指定 SQL Server 資料庫的狀態。 將此參數設為 Online 可讓資料庫能夠控管新的網站。 將此參數設定為 Disabled,讓資料庫無法裝載新網站。

此類型必須是下列其中一項:[線上] 或 [已停用]

Type:SPObjectStatus
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-WarningSiteCount

指定警告事件產生之前所能建立的網站集合數量,以及所要通知的網站集合擁有者。

此類型必須是正整數。 若設定 $null,可清除此值。

Type:Int32
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-WhatIf

顯示訊息會描述命令的功效而不執行命令。 如需詳細資訊,請輸入下列命令:get-help about_commonparameters

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition