Restore-AzSqlInstanceDatabase
還原 Azure SQL 受控執行個體 資料庫。
Syntax
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>]
Description
Restore-AzSqlInstanceDatabase Cmdlet 會從異地備援備份、實時資料庫中的時間點或長期保留備份還原實例資料庫。 還原的資料庫會建立為新的實例資料庫。
範例
範例 1:從某個時間點還原實例資料庫
Restore-AzSqlInstanceDatabase -Name "Database01" -InstanceName "managedInstance1" -ResourceGroupName "ResourceGroup01" -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored"
命令會將實例資料庫 Database01 從指定的時間點備份還原至名為 Database01_restored 的實例資料庫。
範例 2:將實例資料庫從某個時間點還原至不同資源群組上的另一個實例
Restore-AzSqlInstanceDatabase -Name "Database01" -InstanceName "managedInstance1" -ResourceGroupName "ResourceGroup01" -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored" -TargetInstanceName "managedInstance1" -TargetResourceGroupName "ResourceGroup02"
命令會將資源群組 ResourceGroup01 上受控實例資料庫 Database01 上的實例資料庫從指定的時間點備份還原至資源群組 ResourceGroup02 上實例 managedInstance2 上名為 Database01_restored的實例資料庫。
範例 3:異地還原實例資料庫
$GeoBackup = Get-AzSqlInstanceDatabaseGeoBackup -ResourceGroupName "ResourceGroup01" -InstanceName "managedInstance1" -Name "Database01"
$GeoBackup | Restore-AzSqlInstanceDatabase -FromGeoBackup -TargetInstanceDatabaseName "Database01_restored" -TargetInstanceName "managedInstance2" -TargetResourceGroupName "ResourceGroup02"
第一個命令會取得名為 Database01 的資料庫異地備援備份,然後將它儲存在$GeoBackup變數中。 第二個命令會將 $GeoBackup 中的備份還原至名為 Database01_restored 的實例資料庫。
範例 4:從某個時間點還原已刪除的實例資料庫
$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"
第一個命令會取得實例 『managedInstance1』 上名為 『DB1』 的已刪除實例資料庫。 第二個命令會將擷取的資料庫從指定的時間點備份還原至名為 Database01_restored 的實例資料庫。
範例 5:從某個時間點還原已刪除的實例資料庫
$deletedDatabase = Get-AzSqlDeletedInstanceDatabaseBackup -ResourceGroupName "ResourceGroup01" -InstanceName "managedInstance1" -DatabaseName "DB1"
Restore-AzSqlInstanceDatabase -FromPointInTimeBackup -InputObject $deletedDatabase[0] -PointInTime UTCDateTime -TargetInstanceDatabaseName "Database01_restored"
第一個命令會取得實例 『managedInstance1』 上名為 『DB1』 的已刪除實例資料庫。 第二個命令會使用輸入物件,將所擷取的資料庫從指定的時間點備份還原到名為 Database01_restored 的實例資料庫。
範例 6:從 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
使用指定的資源標識碼還原 LTR 備份(執行 Get-AzSqlInstanceDatabaseLongTermRetentionBackup 即可找到備份)。
範例 7. 從不同的訂用帳戶還原資料庫
Restore-AzSqlInstanceDatabase -FromPointInTimeBackup `
-SubscriptionId "sourceSubscriptionID" `
-ResourceGroupName "sourceRGName" `
-InstanceName "sourceManagedInstanceName" `
-Name "sourceDatabaseName" `
-PointInTime $pointInTime `
-TargetInstanceDatabaseName "targetDatabaseName" `
-TargetInstanceName "targetManagedInstnaceName" `
-TargetResourceGroupName "targetResourceGroupName" `
-TargetSubscriptionId "targetSubscriptionId"
命令會將一個訂用帳戶中的 實例的資料庫備份還原至實例上的資料庫targetDatabaseName
,還原至不同的訂用帳戶 targetSubscriptionId
。targetManagedInstanceName
範例 8. 使用來源物件和管線從不同的訂用帳戶還原資料庫
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"
第一個命令會取得來源受控資料庫物件,並儲存在變數 sourceDatabase 中。 第二個命令會使用時間點還原,執行從來源還原至指定目標資料庫的還原。
參數
-AsJob
在背景執行 Cmdlet
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
執行 Cmdlet 之前先提示您確認。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DeletionDate
已刪除資料庫的刪除日期。
Type: | DateTime |
Position: | 3 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-FromGeoBackup
從異地備份還原。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-FromLongTermRetentionBackup
從長期保留備份還原。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-FromPointInTimeBackup
從時間點備份還原。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-GeoBackupObject
要還原的可復原實例資料庫物件
Type: | AzureSqlRecoverableManagedDatabaseModel |
Aliases: | RecoverableInstanceDatabase |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-InputObject
要還原的 Instance Database 物件
Type: | AzureSqlManagedDatabaseBaseModel |
Aliases: | InstanceDatabase |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-InstanceName
實例名稱。
Type: | String |
Aliases: | SourceInstanceName |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
要還原的實例資料庫名稱。
Type: | String |
Aliases: | InstanceDatabaseName, SourceInstanceDatabaseName |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PointInTime
還原資料庫的時間點。
Type: | DateTime |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
資源群組的名稱。
Type: | String |
Aliases: | SourceResourceGroupName |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
要還原的 Instance Database 對象資源標識碼
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SubscriptionId
來源訂用帳戶標識碼。
Type: | String |
Aliases: | SourceSubscriptionId |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetInstanceDatabaseName
要還原的目標實例資料庫名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetInstanceName
要還原的目標實例名稱。 如果未指定,則目標實例與來源實例相同。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetResourceGroupName
要還原的目標資源群組名稱。 如果未指定,則目標資源群組與來源資源群組相同。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetSubscriptionId
要還原的目標訂用帳戶標識碼名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
顯示執行 Cmdlet 後會發生的情況。 未執行 Cmdlet。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
輸入
AzureSqlManagedDatabaseBaseModel
AzureSqlRecoverableManagedDatabaseModel
輸出
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應