Get-AzSqlInstanceDatabaseLongTermRetentionBackup

  • Riferimento
Modulo:
Az.Sql

Ottiene i backup di conservazione a lungo termine.

Sintassi

Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-Location] <String>
   [-ResourceGroupName <String>]
   [-OnlyLatestPerDatabase]
   [-DatabaseState <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-Location] <String>
   [-InstanceName] <String>
   [-ResourceGroupName <String>]
   [-OnlyLatestPerDatabase]
   [-DatabaseState <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-Location] <String>
   [-InstanceName] <String>
   [-DatabaseName] <String>
   [-ResourceGroupName <String>]
   [-OnlyLatestPerDatabase]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-Location] <String>
   [-InstanceName] <String>
   [-DatabaseName] <String>
   [-BackupName] <String>
   [-ResourceGroupName <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-Location] <String>
   [-ResourceId] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-InputObject] <AzureSqlManagedDatabaseModel>
   [-BackupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Get-AzSqlInstanceDatabaseLongTermRetentionBackup
   [-InputObject] <AzureSqlManagedDatabaseModel>
   [-OnlyLatestPerDatabase]
   [-DatabaseState <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Descrizione

Il cmdlet Get-AzSqlInstanceDatabaseLongTermRetentionBackup ottiene backup di conservazione a lungo termine.

Esempio

Esempio 1

Get-AzSqlInstanceDatabaseLongTermRetentionBackup -Location southeastasia -ResourceGroupName testResourceGroup -InstanceName testInstance -DatabaseName test

BackupExpirationTime : 3/10/2020 1:10:45 PM
BackupName           : 15be823c-7e2c-49d8-819f-a3fdcad92215;132268250550000000
BackupTime           : 2/22/2020 6:04:15 AM
DatabaseName         : test
DatabaseDeletionTime : 2/24/2020 2:56:44 PM
Location             : southeastasia
ResourceId           : /subscriptions/f46521f3-5bb0-4eea-a3c2-c2d5987df96b/resourceGroups/testResourceGroup/providers/Microsoft.Sql/locations/southeastasia/longTermRetentionManaged
                       Instances/testInstance/longTermRetentionDatabases/test/longTermRetentionManagedInstanceBackups/15be823c-7e2c-49d8-819f-a3fdcad92215;132268250550000000
ManagedInstanceName  : testInstance
InstanceCreateTime   : 10/17/2019 4:52:10 PM
ResourceGroupName    : testResourceGroup

Ottiene tutti i backup di conservazione a lungo termine per un determinato database. Il gruppo di risorse è facoltativo.

Parametri

-BackupName

Nome del backup.

Type:String
Position:3
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:True

-Confirm

Richiede conferma prima di eseguire il cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-DatabaseName

Nome del database gestito in cui si trovano i backup.

Type:String
Position:2
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-DatabaseState

Stato del database di cui si desidera trovare i backup, Alive, Deleted o All. Il valore predefinito è Tutti

Type:String
Accepted values:All, Deleted, Live
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-DefaultProfile

Le credenziali, l’account, il tenant e la sottoscrizione usati per comunicare con Azure.

Type:IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-InputObject

Oggetto di database per cui ottenere i backup.

Type:AzureSqlManagedDatabaseModel
Position:0
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-InstanceName

Nome del Istanza gestita i backup sono inclusi.

Type:String
Position:1
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Location

Percorso del Istanza gestita di origine dei backup.

Type:String
Position:0
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-OnlyLatestPerDatabase

Indica se ottenere o meno solo il backup più recente per ogni database. Il valore predefinito è falso.

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ResourceGroupName

Nome del gruppo di risorse.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ResourceId

ID risorsa del database per cui ottenere i backup.

Type:String
Position:0
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-WhatIf

Mostra gli effetti dell'esecuzione del cmdlet. Il cmdlet non viene eseguito.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Input

AzureSqlManagedDatabaseModel

String

Output

AzureSqlManagedDatabaseLongTermRetentionBackupModel