Site icon TheWindowsUpdate.com

InvalidMaxSizeTierCombination error while performing scaling up operation

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

Worked on a service request where the customer was getting an error InvalidMaxSizeTierCombination while performing the scaling up operation.

 

Basically, the customer was trying to scale up the storage of his Azure SQL database from 500 GB to 1TB in the premium p6 tier.

The customer was reported below error message

Status message:

{

    'status': 'Failed',

    'error': {

        'code': 'InvalidMaxSizeTierCombination',

        'message': 'The tier 'Premium' does not support the database max size '1073741824000'.'

    }

}

 

Here is the things happened.

When I tried using the PowerShell with the same max limit value, I got a similar error.

As per the calculation instead of 1024000*1024*1024=1073741824000, we have to give 1099511627776

 

Example-

1TB

1 * 1024 GB

1 * 1024 * 1024 - MB

1 * 1024 * 1024 * 1024 - KB

1 * 1024 * 1024 * 1024 * 1024 – Bytes

 

 

Set-AzSqlDatabase -ResourceGroupName "<rgname>" -DatabaseName "<dbname>" -ServerName "<servername>" -Edition "premium" -RequestedServiceObjectiveName "P6" -MaxSizeBytes 1099511627776

 

PowerShell snippet for reference

 

Happy learning!

 

Exit mobile version