Get-AzSqlInstanceDatabaseCopyOperation
取得受控資料庫複製作業詳細數據
Syntax
Get-AzSqlInstanceDatabaseCopyOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseCopyOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseCopyOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-ModelObject <MoveCopyManagedDatabaseModel>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseCopyOperation
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-ResourceId <String>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
Get-AzSqlInstanceDatabaseCopyOperation Cmdlet 會取得複製受控資料庫作業詳細數據。
範例
範例 1:取得單一 Azure SQL 受控執行個體 上的所有複製作業
Get-AzSqlInstanceDatabaseCopyOperation -ResourceGroupName RG1 -InstanceName instance1
Name : 11111111-1111-1111-1111-111111111111
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/11111111-1111-1111-1111-111111111111
Operation : StartCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Start Azure SQL Managed Instance database copy
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance2
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance2
SourceDatabaseName : db1
TargetDatabaseName : db1
IsCancellable : True
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
Name : 22222222-2222-2222-2222-222222222222
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/22222222-2222-2222-2222-222222222222
Operation : StartCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Start Azure SQL Managed Instance database copy
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance3
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance3
SourceDatabaseName : db2
TargetDatabaseName : db2
IsCancellable : True
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
Name : 33333333-3333-3333-3333-333333333333
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/33333333-3333-3333-3333-333333333333
Operation : CancelCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Cancel Azure SQL Managed Instance database copy
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance3
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance3
SourceDatabaseName : db2
TargetDatabaseName : db2
IsCancellable : False
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
此命令會傳回資源群組 RG1 中 instance1 的所有複製作業。
範例 2:取得一個資料庫 Azure SQL 受控執行個體 上的所有複製作業
Get-AzSqlInstanceDatabaseCopyOperation -ResourceGroupName RG1 -InstanceName instance1 -DatabaseName db2
Name : 22222222-2222-2222-2222-222222222222
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/22222222-2222-2222-2222-222222222222
Operation : StartCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Start Azure SQL Managed Instance database copy
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance3
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance3
SourceDatabaseName : db2
TargetDatabaseName : db2
IsCancellable : True
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
Name : 33333333-3333-3333-3333-333333333333
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/33333333-3333-3333-3333-333333333333
Operation : CancelCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Cancel Azure SQL Managed Instance database copy
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance3
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance3
SourceDatabaseName : db2
TargetDatabaseName : db2
IsCancellable : False
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
此命令會傳回資源群組 RG1 實例 1 上資料庫 db2 的所有複製作業。
範例 3:只取得一個資料庫 Azure SQL 受控執行個體 的最新複製作業
Get-AzSqlInstanceDatabaseCopyOperation -ResourceGroupName RG1 -InstanceName instance1 -DatabaseName db2 -OnlyLatestPerDatabase
Name : 33333333-3333-3333-3333-333333333333
Id : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/locations/westcentralus/managedDatabaseMoveOperationResults/33333333-3333-3333-3333-333333333333
Operation : CancelCrossManagedInstanceDatabaseMovement
OperationFriendlyName : Cancel Azure SQL Managed Instance database copy
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Copy
SourceManagedInstanceName : instance1
TargetManagedInstanceName : instance3
SourceManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microso
ft.Sql/managedInstances/instance1
TargetManagedInstanceId : /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/RG1/providers/Microsoft.Sql/managedInstances/instance3
SourceDatabaseName : db2
TargetDatabaseName : db2
IsCancellable : False
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
此命令會傳回資源群組 RG1 實例 1 上資料庫 db2 的最新複製作業。
參數
-DatabaseName
Azure SQL 受控執行個體 上的資料庫名稱。
Type: | String |
Aliases: | Name |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseObject
Managed 資料庫物件。
Type: | AzureSqlManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
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 |
-InstanceName
執行個體的名稱。
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ModelObject
使用 -PassThru 參數從開始移動或複製作業傳回的物件。
Type: | MoveCopyManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-OnlyLatestPerDatabase
每個受控資料庫只傳回最新的作業
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
資源群組的名稱。
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceId
受控資料庫的資源標識碼。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TargetInstanceName
目標 Azure SQL 受控執行個體 的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetResourceGroupName
目標資源群組的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
輸入
輸出
ManagedDatabaseMoveCopyOperation
相關連結
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應