Set-AzSqlInstanceDtc
Définit les propriétés d’une instance managée Azure SQL Managed Instance DTC
Syntax
Set-AzSqlInstanceDtc
[-ResourceGroupName] <String>
[-InstanceName] <String>
[[-DtcEnabled] <Boolean>]
[[-ExternalDnsSuffixSearchList] <System.Collections.Generic.List`1[System.String]>]
[-XaTransactionsEnabled <Boolean>]
[-SnaLu6point2TransactionsEnabled <Boolean>]
[-XaTransactionsDefaultTimeout <Int32>]
[-XaTransactionsMaximumTimeout <Int32>]
[-AllowInboundEnabled <Boolean>]
[-AllowOutboundEnabled <Boolean>]
[-Authentication <String>]
[-AsJob]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlInstanceDtc
[-InstanceObject] <AzureSqlManagedInstanceModel>
[[-DtcEnabled] <Boolean>]
[[-ExternalDnsSuffixSearchList] <System.Collections.Generic.List`1[System.String]>]
[-XaTransactionsEnabled <Boolean>]
[-SnaLu6point2TransactionsEnabled <Boolean>]
[-XaTransactionsDefaultTimeout <Int32>]
[-XaTransactionsMaximumTimeout <Int32>]
[-AllowInboundEnabled <Boolean>]
[-AllowOutboundEnabled <Boolean>]
[-Authentication <String>]
[-AsJob]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlInstanceDtc
[-InputObject] <AzureSqlManagedInstanceDtcModel>
[[-DtcEnabled] <Boolean>]
[[-ExternalDnsSuffixSearchList] <System.Collections.Generic.List`1[System.String]>]
[-XaTransactionsEnabled <Boolean>]
[-SnaLu6point2TransactionsEnabled <Boolean>]
[-XaTransactionsDefaultTimeout <Int32>]
[-XaTransactionsMaximumTimeout <Int32>]
[-AllowInboundEnabled <Boolean>]
[-AllowOutboundEnabled <Boolean>]
[-Authentication <String>]
[-AsJob]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSqlInstanceDtc
[-ResourceId] <String>
[[-DtcEnabled] <Boolean>]
[[-ExternalDnsSuffixSearchList] <System.Collections.Generic.List`1[System.String]>]
[-XaTransactionsEnabled <Boolean>]
[-SnaLu6point2TransactionsEnabled <Boolean>]
[-XaTransactionsDefaultTimeout <Int32>]
[-XaTransactionsMaximumTimeout <Int32>]
[-AllowInboundEnabled <Boolean>]
[-AllowOutboundEnabled <Boolean>]
[-Authentication <String>]
[-AsJob]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
L’applet de commande Set-AzSqlInstanceDtc modifie les propriétés d’une instance managée Azure SQL DTC.
Exemples
Exemple 1 Activer DTC pour une instance managée
Set-AzSqlInstanceDtc -ResourceGroupName ResourceGroup1 -InstanceName ManagedInstance1 -DtcEnabled $true
ResourceGroupName : ResourceGroup1
ManagedInstanceName : ManagedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup1/providers/Microsoft.Sql/managedInstances/ManagedInstance1/dtc/current
DtcEnabled : True
DtcHostNameDnsSuffix : suffix1.net
DtcHostName : name1.suffix1.net
ExternalDnsSuffixSearchList : {suffix1.net}
SecuritySettings : Microsoft.Azure.Management.Sql.Models.ManagedInstanceDtcSecuritySettings
Cette commande active managed instance DTC pour l’instance managée ManagedInstance1.
Exemple 2 Activer les transactions XA pour DTC
$dtc = Set-AzSqlInstanceDtc -ResourceGroupName ResourceGroup1 -InstanceName ManagedInstance1 -XaTransactionsEnabled $true
Write-Output $dtc.SecuritySettings
TransactionManagerCommunicationSettings : Microsoft.Azure.Management.Sql.Models.ManagedInstanceDtcTransactionManagerCommunicationSettings
XaTransactionsEnabled : True
SnaLu6point2TransactionsEnabled : True
XaTransactionsDefaultTimeout : 0
XaTransactionsMaximumTimeout : 0
Cette commande active les transactions XA pour le DTC d’instance managée
Exemple 3 Activer DTC pour une instance managée récupérée précédemment
$managedInstance = Get-AzSqlInstance -ResourceGroupName ResourceGroup1 -InstanceName ManagedInstance1
Set-AzSqlInstanceDtc -InstanceObject $managedInstance
ResourceGroupName : ResourceGroup1
ManagedInstanceName : ManagedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup1/providers/Microsoft.Sql/managedInstances/ManagedInstance1/dtc/current
DtcEnabled : True
DtcHostNameDnsSuffix : suffix1.net
DtcHostName : name1.suffix1.net
ExternalDnsSuffixSearchList : {suffix1.net}
SecuritySettings : Microsoft.Azure.Management.Sql.Models.ManagedInstanceDtcSecuritySettings
Cette commande active la DTC de l’instance managée en passant l’objet d’instance managée.
Exemple 4 Activer les transactions XA pour un objet DTC extrait précédemment
$dtc = Get-AzSqlInstanceDtc -ResourceGroupName ResourceGroup1 -InstanceName ManagedInstance1
$dtc = Set-AzSqlInstanceDtc -InputObject $dtc -DtcEnabled $true
Write-Output $dtc.SecuritySettings
TransactionManagerCommunicationSettings : Microsoft.Azure.Management.Sql.Models.ManagedInstanceDtcTransactionManagerCommunicationSettings
XaTransactionsEnabled : True
SnaLu6point2TransactionsEnabled : True
XaTransactionsDefaultTimeout : 0
XaTransactionsMaximumTimeout : 0
Cette commande active les transactions XA pour DTC en passant un objet DTC.
Exemple 5 Activer DTC avec un ID de ressource spécifique
Set-AzSqlInstanceDtc -ResourceId /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup1/providers/Microsoft.Sql/managedInstances/ManagedInstance1/dtc/current -DtcEnabled $true
ResourceGroupName : ResourceGroup1
ManagedInstanceName : ManagedInstance1
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup1/providers/Microsoft.Sql/managedInstances/ManagedInstance1/dtc/current
DtcEnabled : True
DtcHostNameDnsSuffix : suffix1.net
DtcHostName : name1.suffix1.net
ExternalDnsSuffixSearchList : {suffix1.net}
SecuritySettings : Microsoft.Azure.Management.Sql.Models.ManagedInstanceDtcSecuritySettings
Cette commande active la DTC de l’instance managée en transmettant l’ID de ressource du DTC.
Paramètres
-AllowInboundEnabled
Activez le trafic entrant.
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-AllowOutboundEnabled
Activez le trafic sortant.
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-AsJob
Exécutez l’applet de commande en arrière-plan.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Authentication
Type d’authentification.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Vous demande une confirmation avant d’exécuter l’applet de commande.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
Informations d’identification, compte, locataire et abonnement utilisés pour la communication avec Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DtcEnabled
État DTC activé.
Type: | Nullable<T>[Boolean] |
Position: | 2 |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ExternalDnsSuffixSearchList
Liste de recherche de suffixes DNS externes.
Type: | List<T>[String] |
Position: | 3 |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Force
Ignorez le message de confirmation pour effectuer l’action.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InputObject
Objet d’entrée de l’instance managée DTC.
Type: | AzureSqlManagedInstanceDtcModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-InstanceName
Nom de l’instance managée.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceObject
Objet d’entrée de l’instance managée.
Type: | AzureSqlManagedInstanceModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceGroupName
Nom du groupe de ressources.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
ID de ressource de l’instance managée DTC.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SnaLu6point2TransactionsEnabled
État des transactions SNA LU 6.2 activées.
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Montre ce qui se passe en cas d’exécution de l’applet de commande. L’applet de commande n’est pas exécutée.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-XaTransactionsDefaultTimeout
Délai d’expiration par défaut des transactions XA.
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-XaTransactionsEnabled
État des transactions XA activées.
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-XaTransactionsMaximumTimeout
Délai d’expiration maximal des transactions XA.
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Entrées
AzureSqlManagedInstanceDtcModel
Sorties
AzureSqlManagedInstanceDtcModel
Liens associés
Commentaires
https://aka.ms/ContentUserFeedback.
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultezEnvoyer et afficher des commentaires pour