Get-AzSynapseDroppedSqlPool
Gets a dropped Sql pool backup of a Synapse Sql Pool.
Syntax
Get-AzSynapseDroppedSqlPool
-ResourceGroupName <String>
-WorkspaceName <String>
[-Name <String>]
[-DeletionDate <DateTime>]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSynapseDroppedSqlPool
[-DeletionDate <DateTime>]
[-ResourceId <String>]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Description
The Get-AzSynapseDroppedSqlPool cmdlet gets a specified deleted SQL pool backup that you can restore, or all deleted backups that you can restore in a workspace.
Examples
Example 1: Get a specified dropped sqlpools from a sql pool
Get-AzSynapseDroppedSqlPool -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -Name "ContosoSqlPool"The cmdlet retrieves dropped sqlpools for a sql pool.
Example 2: Get all dropped sqlpool on a workspace
Get-AzSynapseDroppedSqlPool -ResourceGroupName "ContosoResourceGroup" -WorkspaceName "ContosoWorkspace"This command gets all available dropped sqlpool on a specified workspace.
Parameters
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DeletionDate
The deletion date of the Azure Synaspe SQL Database to retrieve backups for, with millisecond precision (e.g. 2016-02-23T00:21:22.847Z)
| Type: | Nullable<T>[DateTime] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Name
The Synapse Sql pool.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
Resource group name.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceId
Input a Dropped Sql Pool Resource Id.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-WorkspaceName
Name of Synapse workspace.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Inputs
Microsoft.Azure.Commands.Synapse.Models.PSSynapseResourceGroup
Outputs
Microsoft.Azure.Commands.Synapse.Models.PSDroppedSqlPoolBackupModel
Azure PowerShell