Get-AzSqlInstanceDatabaseMoveOperation
Mendapatkan detail operasi pemindahan database terkelola
Sintaks
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>]
Deskripsi
Cmdlet Get-AzSqlInstanceDatabaseMoveOperation mendapatkan detail operasi database terkelola pemindahan.
Contoh
Contoh 1: Dapatkan semua operasi pemindahan pada Azure SQL Managed Instance tunggal
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 :
Perintah ini akan mengembalikan semua operasi pemindahan untuk instans1 dalam grup sumber daya RG1.
Contoh 2: Mendapatkan semua operasi pemindahan di Azure SQL Managed Instance untuk satu database
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 :
Perintah ini akan mengembalikan semua operasi pemindahan untuk database db2 pada instans 1 dalam grup sumber daya RG1.
Contoh 3: Hanya dapatkan operasi pemindahan terbaru di Azure SQL Managed Instance untuk satu database
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 :
Perintah ini akan mengembalikan operasi pemindahan terbaru untuk database db2 pada instans instance1 di grup sumber daya RG1.
Parameter
-DatabaseName
Nama database di Azure SQL Managed Instance.
Type: | String |
Aliases: | Name |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseObject
Objek database terkelola.
Type: | AzureSqlManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceName
Nama instans.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ModelObject
Objek yang dikembalikan dari operasi mulai pemindahan atau salin menggunakan parameter -PassThru.
Type: | MoveCopyManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-OnlyLatestPerDatabase
Mengembalikan hanya opereasi terbaru per database terkelola
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
Nama grup sumber daya.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceId
Id sumber daya database terkelola.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TargetInstanceName
Nama target Azure SQL Managed Instance.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetResourceGroupName
Nama grup sumber daya target.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Input
Output
ManagedDatabaseMoveCopyOperation
Link Terkait
Azure PowerShell
Saran dan Komentar
https://aka.ms/ContentUserFeedback.
Segera hadir: Sepanjang tahun 2024 kami akan menghentikan penggunaan GitHub Issues sebagai mekanisme umpan balik untuk konten dan menggantinya dengan sistem umpan balik baru. Untuk mengetahui informasi selengkapnya, lihat:Kirim dan lihat umpan balik untuk