Get-AzSqlInstanceDatabaseGeoBackup
Gibt Informationen zur redundanten Sicherung von Azure SQL verwaltete Instanz-Datenbank zurück.
Syntax
Get-AzSqlInstanceDatabaseGeoBackup
[[-Name] <String>]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Beschreibung
Das Cmdlet Get-AzSqlInstanceDatabaseGeoBackup ruft eine oder mehrere redundante Azure SQL-Datenbanken aus einem Azure SQL-Datenbank verwaltete Instanz ab.
Beispiele
Beispiel 1: Abrufen aller redundanten Datenbanksicherungen für eine Instanz
Get-AzSqlInstanceDatabaseGeoBackup -InstanceName "managedInstance1" -ResourceGroupName "resourcegroup01"
ResourceGroupName : resourcegroup01
ManagedInstanceName : managedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
Name : managedDatabase1
LastAvailableBackupDate : 01/31/2019 20:44:57
RecoverableDatabaseId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
ResourceGroupName : resourcegroup01
ManagedInstanceName : managedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase2
Name : managedDatabase2
LastAvailableBackupDate : 01/31/2019 20:44:57
RecoverableDatabaseId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase2
Dieser Befehl ruft alle redundanten Datenbanksicherungen für die Instanz mit dem Namen managedInstance1 ab.
Beispiel 2: Abrufen einer redundanten Datenbanksicherung anhand des Namens in einer verwalteten Instanz
Get-AzSqlInstanceDatabaseGeoBackup -Name "managedDatabase1" -InstanceName "managedInstance1" -ResourceGroupName "ResourceGroup01"
ResourceGroupName : resourcegroup01
ManagedInstanceName : managedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
Name : managedDatabase1
LastAvailableBackupDate : 01/31/2019 20:44:57
RecoverableDatabaseId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
Dieser Befehl ruft eine redundante Datenbanksicherung namens managedDatabase1 aus einer Instanz namens managedInstance1 ab.
Beispiel 3: Abrufen aller redundanten Datenbanksicherungen für eine Instanz mithilfe von Filterung
Get-AzSqlInstanceDatabaseGeoBackup -InstanceName "managedInstance1" -ResourceGroupName "resourcegroup01" -Name "managedDatabase*"
ResourceGroupName : resourcegroup01
ManagedInstanceName : managedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
Name : managedDatabase1
LastAvailableBackupDate : 01/31/2019 20:44:57
RecoverableDatabaseId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase1
ResourceGroupName : resourcegroup01
ManagedInstanceName : managedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase2
Name : managedDatabase2
LastAvailableBackupDate : 01/31/2019 20:44:57
RecoverableDatabaseId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/managedInstances/managedInstance1/recoverableDatabases/managedDatabase2
Dieser Befehl ruft alle redundanten Datenbanksicherungen für die Instanz mit dem Namen managedInstance1 ab, die mit "managedDatabase" beginnen.
Parameter
-DefaultProfile
Anmeldeinformationen, Konto, Mandant und Abonnement für die Kommunikation mit Azure
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceName
Der Name der Instanz.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Der Name der abzurufenden Instanzdatenbank.
Type: | String |
Aliases: | RecoverableInstanceDatabaseName |
Position: | 0 |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | True |
-ResourceGroupName
Der Name der Ressourcengruppe.
Type: | String |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Eingaben
None
Ausgaben
Azure PowerShell
Feedback
https://aka.ms/ContentUserFeedback.
Bald verfügbar: Im Laufe des Jahres 2024 werden wir GitHub-Issues stufenweise als Feedbackmechanismus für Inhalte abbauen und durch ein neues Feedbacksystem ersetzen. Weitere Informationen finden Sie unterFeedback senden und anzeigen für