Restore-AzSqlInstanceDatabase
Memulihkan database Azure SQL Managed Instance.
Sintaks
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-SubscriptionId <String>]
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-InputObject] <AzureSqlManagedDatabaseBaseModel>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-ResourceId] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-SubscriptionId <String>]
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-InputObject] <AzureSqlManagedDatabaseBaseModel>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-ResourceId] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-SubscriptionId <String>]
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
[-DeletionDate] <DateTime>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-SubscriptionId <String>]
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
[-DeletionDate] <DateTime>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
-SubscriptionId <String>
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
-TargetSubscriptionId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-InputObject] <AzureSqlManagedDatabaseBaseModel>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
-TargetSubscriptionId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
[-ResourceId] <String>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
-TargetSubscriptionId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromPointInTimeBackup]
-SubscriptionId <String>
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
[-DeletionDate] <DateTime>
-PointInTime <DateTime>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
-TargetSubscriptionId <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromGeoBackup]
[-GeoBackupObject] <AzureSqlRecoverableManagedDatabaseModel>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromGeoBackup]
[-ResourceId] <String>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromGeoBackup]
[-ResourceGroupName] <String>
[-InstanceName] <String>
[-Name] <String>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Restore-AzSqlInstanceDatabase
[-FromLongTermRetentionBackup]
[-SubscriptionId <String>]
[-ResourceId] <String>
-TargetInstanceDatabaseName <String>
-TargetInstanceName <String>
-TargetResourceGroupName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Deskripsi
Cmdlet Restore-AzSqlInstanceDatabase memulihkan database instans dari cadangan geo-redundan, titik waktu dalam database langsung, atau cadangan retensi jangka panjang. Database yang dipulihkan dibuat sebagai database instans baru.
Contoh
Contoh 1: Memulihkan database instans dari titik waktu tertentu
Restore-AzSqlInstanceDatabase -Name "Database01" -InstanceName "managedInstance1" -ResourceGroupName "ResourceGroup01" -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored"
Perintah memulihkan database instans Database01 dari cadangan point-in-time yang ditentukan ke database instans bernama Database01_restored.
Contoh 2: Memulihkan database instans dari titik waktu ke instans lain pada grup sumber daya yang berbeda
Restore-AzSqlInstanceDatabase -Name "Database01" -InstanceName "managedInstance1" -ResourceGroupName "ResourceGroup01" -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored" -TargetInstanceName "managedInstance1" -TargetResourceGroupName "ResourceGroup02"
Perintah memulihkan database instans Database01 pada instans managedInstance1 pada grup sumber daya ResourceGroup01 dari cadangan titik waktu yang ditentukan ke database instans bernama Database01_restored pada instans managedInstance2 pada grup sumber daya ResourceGroup02.
Contoh 3: Pemulihan Geografis database instans
$GeoBackup = Get-AzSqlInstanceDatabaseGeoBackup -ResourceGroupName "ResourceGroup01" -InstanceName "managedInstance1" -Name "Database01"
$GeoBackup | Restore-AzSqlInstanceDatabase -FromGeoBackup -TargetInstanceDatabaseName "Database01_restored" -TargetInstanceName "managedInstance2" -TargetResourceGroupName "ResourceGroup02"
Perintah pertama mendapatkan cadangan geo-redundan untuk database bernama Database01, lalu menyimpannya dalam variabel $GeoBackup. Perintah kedua memulihkan cadangan dalam $GeoBackup ke database instans bernama Database01_restored.
Contoh 4: Memulihkan database instans yang dihapus dari titik waktu tertentu
$deletedDatabase = Get-AzSqlDeletedInstanceDatabaseBackup -ResourceGroupName "ResourceGroup01" -InstanceName "managedInstance1" -DatabaseName "DB1"
Restore-AzSqlInstanceDatabase -FromPointInTimeBackup -Name $deletedDatabase.Name -InstanceName $deletedDatabase.ManagedInstanceName -ResourceGroupName $deletedDatabase.ResourceGroupName -DeletionDate $deletedDatabase.DeletionDate -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored"
Perintah pertama mendapatkan database instans yang dihapus bernama 'DB1' pada Instans 'managedInstance1'. Perintah kedua memulihkan database yang diambil, dari cadangan point-in-time yang ditentukan ke database instans bernama Database01_restored.
Contoh 5: Memulihkan database instans yang dihapus dari titik waktu tertentu
$deletedDatabase = Get-AzSqlDeletedInstanceDatabaseBackup -ResourceGroupName "ResourceGroup01" -InstanceName "managedInstance1" -DatabaseName "DB1"
Restore-AzSqlInstanceDatabase -FromPointInTimeBackup -InputObject $deletedDatabase[0] -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored"
Perintah pertama mendapatkan database instans yang dihapus bernama 'DB1' pada Instans 'managedInstance1'. Perintah kedua memulihkan database yang diambil, dari cadangan point-in-time yang ditentukan ke database instans bernama Database01_restored menggunakan objek input.
Contoh 6: Memulihkan database dari cadangan LTR.
Restore-AzSqlInstanceDatabase -FromLongTermRetentionBackup -ResourceId "/subscriptions/f46521f3-5bb0-4eea-a3c2-c2d5987df96b/resourceGroups/testResourceGroup/providers/Microsoft.Sql/locations/southeastasia/longTermRetentionManagedInstances/testInstance/longTermRetentionDatabases/test/longTermRetentionManagedInstanceBackups/15be823c-7e2c-49d8-819f-a3fdcad92215;132268250550000000" -TargetInstanceDatabaseName "restoreTarget" -TargetInstanceName "testInstance" -TargetResourceGroupName "testResourceGroup"
Location : southeastasia
Tags :
Collation : SQL_Latin1_General_CP1_CI_AS
Status : Online
RestorePointInTime :
DefaultSecondaryLocation : northeurope
CatalogCollation :
CreateMode :
StorageContainerUri :
StorageContainerSasToken :
SourceDatabaseId :
FailoverGroupId :
RecoverableDatabaseId :
RestorableDroppedDatabaseId :
LongTermRetentionBackupResourceId :
ResourceGroupName : testResourceGroup
ManagedInstanceName : testInstance
Name : restoreTarget
CreationDate : 3/4/2020 8:12:56 AM
EarliestRestorePoint : 3/4/2020 8:14:29 AM
Id : /subscriptions/f46521f3-5bb0-4eea-a3c2-c2d5987df96b/resourceGroups/testResourceGroup/providers/Microsoft.Sql/managedInstances/testInstance/databases/restoreTarget
Memulihkan cadangan LTR dengan ID sumber daya yang diberikan (yang dapat ditemukan dengan menjalankan Get-AzSqlInstanceDatabaseLongTermRetentionBackup).
Contoh 7. Memulihkan database dari langganan yang berbeda
Restore-AzSqlInstanceDatabase -FromPointInTimeBackup `
-SubscriptionId "sourceSubscriptionID" `
-ResourceGroupName "sourceRGName" `
-InstanceName "sourceManagedInstanceName" `
-Name "sourceDatabaseName" `
-PointInTime $pointInTime `
-TargetInstanceDatabaseName "targetDatabaseName" `
-TargetInstanceName "targetManagedInstnaceName" `
-TargetResourceGroupName "targetResourceGroupName" `
-TargetSubscriptionId "targetSubscriptionId"
Perintah memulihkan cadangan database dari instans dalam satu langganan ke database targetDatabaseName
pada instans targetManagedInstanceName
ke langganan targetSubscriptionId
yang berbeda .
Contoh 8. Memulihkan database dari langganan yang berbeda menggunakan objek sumber dan pipping
Set-AzContext -SubscriptionId "sourceSubscriptionId"
$sourceDatabase = Get-AzSqlInstanceDatabase -Name "sourceDatabaseName" -InstanceName "sourceManagedInstanceName" -ResourceGroupName "sourceRGName"
Set-AzContext -SubscriptionId "targetSubscriptionId"
$sourceDatabase | Restore-AzSqlInstanceDatabase -FromPointInTimeBackup `
-PointInTime $pointInTime `
-TargetInstanceDatabaseName "targetDatabaseName" `
-TargetInstanceName "targetManagedInstnaceName" `
-TargetResourceGroupName "targetResourceGroupName" `
-TargetSubscriptionId "targetSubscriptionId"
Perintah pertama mendapatkan objek database terkelola sumber dan penyimpanan dalam variabel sourceDatabase. Perintah kedua menjalankan pemulihan dari sumber ke database target yang diberikan menggunakan pemulihan titik waktu.
Parameter
-AsJob
Jalankan cmdlet di latar belakang
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-Confirm
Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.
Jenis: | SwitchParameter |
Alias: | cf |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure
Jenis: | IAzureContextContainer |
Alias: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-DeletionDate
Tanggal penghapusan database yang dihapus.
Jenis: | DateTime |
Position: | 3 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-FromGeoBackup
Pulihkan dari cadangan geografis.
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-FromLongTermRetentionBackup
Pulihkan dari cadangan Retensi Jangka Panjang.
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-FromPointInTimeBackup
Pulihkan dari cadangan point-in-time.
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-GeoBackupObject
Objek database instans yang dapat dipulihkan untuk dipulihkan
Jenis: | AzureSqlRecoverableManagedDatabaseModel |
Alias: | RecoverableInstanceDatabase |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-InputObject
Objek Database Instans untuk dipulihkan
Jenis: | AzureSqlManagedDatabaseBaseModel |
Alias: | InstanceDatabase |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-InstanceName
Nama instans.
Jenis: | String |
Alias: | SourceInstanceName |
Position: | 1 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-Name
Nama database instans yang akan dipulihkan.
Jenis: | String |
Alias: | InstanceDatabaseName, SourceInstanceDatabaseName |
Position: | 2 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-PointInTime
Titik waktu untuk memulihkan database.
Jenis: | DateTime |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-ResourceGroupName
Nama grup sumber daya.
Jenis: | String |
Alias: | SourceResourceGroupName |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-ResourceId
Id sumber daya objek Database Instans untuk dipulihkan
Jenis: | String |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-SubscriptionId
Id langganan sumber.
Jenis: | String |
Alias: | SourceSubscriptionId |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-TargetInstanceDatabaseName
Nama database instans target yang akan dipulihkan.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-TargetInstanceName
Nama instans target yang akan dipulihkan. Jika tidak ditentukan, instans target sama dengan instans sumber.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-TargetResourceGroupName
Nama grup sumber daya target yang akan dipulihkan. Jika tidak ditentukan, grup sumber daya target sama dengan grup sumber daya sumber.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-TargetSubscriptionId
Nama id langganan target yang akan dipulihkan.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-WhatIf
Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.
Jenis: | SwitchParameter |
Alias: | wi |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
Input
AzureSqlManagedDatabaseBaseModel
AzureSqlRecoverableManagedDatabaseModel