Get-SPAccessServicesDatabaseServer

傳回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

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

參數

-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 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServer

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

Type:AccessServicesDatabaseServerPipeBind
Position:Named
Default value:None
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
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
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

輸出

系統.物件