Set-AzSqlInstanceDtc
設定 Azure SQL 受控執行個體 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
Set-AzSqlInstanceDtc Cmdlet 會修改 Azure SQL 受控實例 DTC 的屬性。
範例
範例 1 為受控實例啟用 DTC
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
此命令會針對受控實例 ManagedInstance1 啟用受控實例 DTC。
範例 2 啟用 DTC 的 XA 交易
$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
此命令會啟用受控實例 DTC 的 XA 交易
範例 3 針對先前擷取的受控實例啟用 DTC
$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
此命令會傳遞受控實例物件,以啟用受控實例 DTC。
範例 4 針對先前擷取的 DTC 物件啟用 XA 交易
$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
此命令會藉由傳遞 DTC 物件來啟用 DTC 的 XA 交易。
範例 5 使用特定資源識別碼啟用 DTC
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
此命令會傳遞 DTC 的資源識別碼,以啟用受控實例 DTC。
參數
-AllowInboundEnabled
啟用輸入流量。
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-AllowOutboundEnabled
啟用輸出流量。
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-AsJob
在背景中執行 Cmdlet。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Authentication
驗證類型。
Type: | String |
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 |
-DtcEnabled
已啟用 DTC 的狀態。
Type: | Nullable<T>[Boolean] |
Position: | 2 |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ExternalDnsSuffixSearchList
外部 DNS 後綴搜尋清單。
Type: | List<T>[String] |
Position: | 3 |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Force
略過執行動作的確認訊息。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InputObject
受控實例 DTC 的輸入物件。
Type: | AzureSqlManagedInstanceDtcModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-InstanceName
受控實例的名稱。
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceObject
受控實例的輸入物件。
Type: | AzureSqlManagedInstanceModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-ResourceGroupName
資源群組的名稱。
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
受控實例 DTC 的資源標識碼。
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SnaLu6point2TransactionsEnabled
啟用 SNA LU 6.2 交易的狀態。
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
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 |
-XaTransactionsDefaultTimeout
XA 交易預設逾時。
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-XaTransactionsEnabled
已啟用 XA 交易的狀態。
Type: | Nullable<T>[Boolean] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-XaTransactionsMaximumTimeout
XA 交易逾時上限。
Type: | Nullable<T>[Int32] |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
輸入
AzureSqlManagedInstanceDtcModel
輸出
AzureSqlManagedInstanceDtcModel
相關連結
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應