Get-AzSqlInstanceDatabaseMoveOperation
Hämta information om flyttåtgärder för hanterade databaser
Syntax
Get-AzSqlInstanceDatabaseMoveOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseMoveOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseMoveOperation
[-DatabaseName <String>]
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-ModelObject <MoveCopyManagedDatabaseModel>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstanceDatabaseMoveOperation
[-TargetResourceGroupName <String>]
[-TargetInstanceName <String>]
-ResourceId <String>
[-OnlyLatestPerDatabase]
[-InstanceName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
Cmdleten Get-AzSqlInstanceDatabaseMoveOperation hämtar information om flytt av hanterad databasåtgärd.
Exempel
Exempel 1: Hämta alla flyttåtgärder på en enda Hanterad Azure SQL-instans
Get-AzSqlInstanceDatabaseMoveOperation -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 move
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Move
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 move
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Move
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 move
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Move
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 :
Det här kommandot returnerar alla flyttåtgärder för instans1 i resursgruppen RG1.
Exempel 2: Hämta alla flyttåtgärder i Azure SQL Managed Instance för en databas
Get-AzSqlInstanceDatabaseMoveOperation -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 move
StartTime : 5/30/2023 10:11:21 AM
State : Succeeded
OperationMode : Move
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 move
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Move
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 :
Det här kommandot returnerar alla flyttåtgärder för databas db2 på instans 1 i resursgruppen RG1.
Exempel 3: Hämta endast den senaste flyttåtgärden i Azure SQL Managed Instance för en databas
Get-AzSqlInstanceDatabaseMoveOperation -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 move
StartTime : 5/30/2023 11:11:21 AM
State : Succeeded
OperationMode : Move
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 :
Det här kommandot returnerar den senaste flyttåtgärden för databas db2 på instansinstans1 i resursgruppen RG1.
Parametrar
-DatabaseName
Namnet på en databas på Azure SQL Managed Instance.
Type: | String |
Aliases: | Name |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseObject
Hanterat databasobjekt.
Type: | AzureSqlManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-DefaultProfile
Autentiseringsuppgifter, konto, klientorganisation och prenumeration som används för kommunikation med Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceName
Namnet på instansen.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ModelObject
Objekt som returneras från startflytt eller kopieringsåtgärd med parametern -PassThru.
Type: | MoveCopyManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-OnlyLatestPerDatabase
Returnera endast den senaste opereationen per hanterad databas
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
Namnet på resursgruppen.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceId
Resurs-ID för hanterad databas.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TargetInstanceName
Namnet på den azure SQL-hanterade målinstansen.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetResourceGroupName
Namnet på målresursgruppen.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Indata
Utdata
ManagedDatabaseMoveCopyOperation
Relaterade länkar
Azure PowerShell
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för