Get-SPAccessServicesDatabaseServer

Devuelve SQL Server instancias asociadas a Access Services.

Syntax

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

Description

Devuelve las instancias de SQL Server que están disponibles para su uso con Access Services.

Ejemplos

Ejemplo 1

Get-SPAccessServicesDatabaseServer

Devuelve todas las instancias de SQL Server disponibles para su uso.

Ejemplo 2

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

Devuelve el servidor de base de datos ACCSQL del grupo de servidores de base de datos DEFAULT mediante el contexto de servicio de https://siteUrl.

Parámetros

- 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

- ServiceContext

Especifica el contexto del servicio del que se va a recuperar la información del servidor de base de datos de 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

-DatabaseServer

Especifica un servidor de base de datos existente asociado a 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

Nombre del grupo de servidores de base de datos.

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

Entradas

Microsoft.SharePoint.PowerShell.SPServiceContextPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Salidas

System.Object