search

Azure / azure-powershell

Microsoft Azure PowerShell
Other
4.27k stars 3.87k forks source link

Set-AzSqlDatabase -ReadScale Enabled, ReadScale still shows Disabled #19093

Closed mikemadeja closed 2 years ago

mikemadeja commented 2 years ago

Description

I have a Hyperscale DB, when I try to set it up with ReadScale as Enabled, the command works, but it is still disabled. I have other Hyperscale DBs that are Enabled for ReadScale

Set-AzSqlDatabase -DatabaseName "sqldb" -ServerName "sqlserver" -ResourceGroupName "sqlrg" -ReadScale Enabled

Issue script & Debug output

$Output = Set-AzSqlDatabase -DatabaseName "sqldb" -ServerName "sqlserver" -ResourceGroupName "sqlrg" -ReadScale Enabled

$Output | Select-Object ReadScale

ReadScale
---------
 Disabled

Environment data

Name                           Value
----                           -----
PSVersion                      5.1.22000.653
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.22000.653
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

Module versions

Get-Module Az*

ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Script     2.7.0      Az.Accounts                         {Add-AzEnvironment, Clear-AzContext, Clear-AzDefault, Connect-AzAccount...}
Script     3.6.0      Az.Sql                              {Add-AzSqlDatabaseToFailoverGroup, Add-AzSqlElasticJobStep, Add-AzSqlElasticJobTarget, Add-AzSqlInstanceKeyVaultKey...}

Error output

No error... the command runs and outputs everything but readscale is still disabled.
mikemadeja commented 2 years ago

Well, I made a mistake, I have no replicas set.. but I would say that the output of this should somewhat show that instead of just committing? Thoughts?

dingmeng-xue commented 2 years ago

@mikemadeja , could you share debug log of Set-AzSqlDatabase? You can turn on it via $DebugPreference = "Continue"

ghost commented 2 years ago

Thank you for your feedback. This has been routed to the support team for assistance.

ghost commented 2 years ago

Hi, we're sending this friendly reminder because we haven't heard back from you in a while. We need more information about this issue to help address it. Please be sure to give us your input within the next 7 days. If we don't hear back from you within 14 days of this comment the issue will be automatically closed. Thank you!