Get-SPAccessServicesDatabaseServer

參考

模組:: SharePointServer

適用於:: SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

傳回SQL Server與 Access Services 相關聯的實例。

Syntax

Get-SPAccessServicesDatabaseServer
   [-ServiceContext] <SPServiceContextPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   -DatabaseServer <AccessServicesDatabaseServerPipeBind>
   -DatabaseServerGroup <AccessServicesDatabaseServerGroupPipeBind>
   [<CommonParameters>]

Get-SPAccessServicesDatabaseServer
   [-ServiceContext] <SPServiceContextPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-DatabaseServerGroup <AccessServicesDatabaseServerGroupPipeBind>]
   [<CommonParameters>]

Description

傳回可用於 Access Services 的SQL Server實例。

範例

範例 1

Get-SPAccessServicesDatabaseServer

傳回所有可用SQL Server實例。

範例 2

Get-SPAccessServicesDatabaseServer -DatabaseServer ACCSQL -ServiceContext https://siteUrl -DatabaseServergroup DEFAULT

使用來自的服務內容，從 DEFAULT 資料庫伺服器群組傳回資料庫伺服器 ACCSQL https://siteUrl.

參數

-AssignmentCollection

管理物件以適當處置它們。使用 SPWeb 或 SPSite 等物件可能會耗用大量的記憶體，因此在 Windows PowerShell 指令碼中使用這些物件時，必須適當地管理記憶體。您可以使用 SPAssignment 物件將物件指派給變數，並在不需要時處置這些物件，以釋放記憶體。使用 SPWeb、SPSite 或 SPSiteAdministration 物件時，若未使用指派集合或 Global 參數，將會自動處置這些物件。

使用 Global 參數時，所有物件會包含在全域儲存區內。若未立即使用物件，或未使用 Stop-SPAssignment 命令處置物件，將會發生記憶體不足的狀況。

Type:	SPAssignmentCollection
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServer

指定與 Access Services 相關聯的現有資料庫伺服器。

Type:	AccessServicesDatabaseServerPipeBind
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerGroup

資料庫伺服器群組的名稱。

Type:	AccessServicesDatabaseServerGroupPipeBind
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ServiceContext

指定要從中擷取 Access Services 資料庫伺服器資訊的服務內容。

Type:	SPServiceContextPipeBind
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

輸入

Microsoft.SharePoint.PowerShell.SPServiceContextPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

輸出

System.Object

共用方式為