Forum Discussion

gyvkoff's avatar
gyvkoff
Copper Contributor
Dec 19, 2023
Solved

Cannot scale database to Hyperscale

I have an Azure SQL database currently in service tier Standard (DTU-based purchasing model). I am trying to migrate/scale it to Hyperscale (vCore-based purchasing model).  I am getting error:

 

Failed to scale from Standard S12: 3000 DTUs, 1 TB storage to Hyperscale - Serverless: Standard-series (Gen5), 8 vCores for database: <dbname>.

Error code: .

Error message: The database '<dbname>' on server '<servername>' has service level objective 'SQLDB_HS_S_Gen5_8' which is not supported for use as a job agent database.

 

I'm unclear what is causing this error.  No elastic jobs or agents exist or are defined.

 

  • gyvkoff's avatar
    gyvkoff
    Dec 20, 2023
    I was incorrect - there was one elastic job agent that was created on this db. Once I deleted the agent, I was able to scale.

1 Reply

Sort By
  • gyvkoff's avatar
    gyvkoff
    Copper Contributor
    Dec 20, 2023
    I was incorrect - there was one elastic job agent that was created on this db. Once I deleted the agent, I was able to scale.

Resources