Restoring an Azure SQL database with New-AzureRmSqlDatabaseImport results in error "40619: The edition 'Standard' does not support the database data max size '52428800'"

Question

Restoring an Azure SQL database with New-AzureRmSqlDatabaseImport results in error "40619: The edition 'Standard' does not support the database data max size '52428800'"

Urs Enzler 41

In an Azure DevOps pipeline, we restore a database (it is a small one) with the following PowerShell Script:

$importRequest = New-AzureRmSqlDatabaseImport `
  -ResourceGroupName "Testing" `
  -ServerName "$(sqltestservername)" `
  -DatabaseName "$(sqltestdatabase)" `
  -DatabaseMaxSizeBytes 5000000 `
  -StorageKeyType "StorageAccessKey" `
  -StorageKey $(Get-AzureRmStorageAccountKey -ResourceGroupName "XYZ" -StorageAccountName "XYZ").Value[0] `
  -StorageUri "https://XYZ.bacpac" `
  -Edition Standard `
  -ServiceObjectiveName S0 `
  -AdministratorLogin "XYZ" `
  -AdministratorLoginPassword $(ConvertTo-SecureString -String "XYZ" -AsPlainText -Force)

This results in the following error:
[error]40619: The edition 'Standard' does not support the database data max size '5000000'.

As we understand it:

the number is in bytes, so 5000000 are close to 50MB, which is way below the max DB size of the Standard tier at 250GB.

The script ran successfully for many months until around 14th October 2020. Then the error appeared. The database and the script did not change between successful and failing runs.

So we assume that something on the service side has changed?!?!

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2020-10-16T12:57:59.21+00:00

@Urs Enzler

We are checking this and will get back to you.

Thanks
Navtej S

Accepted answer

1 additional answer

Your answer

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2020-10-16T12:57:59.21+00:00

@Urs Enzler

We are checking this and will get back to you.

Thanks
Navtej S

Answer 1

Simon Redman 76 Microsoft Employee

Hi @Urs Enzler ,

50MB is not a supported value for a Standard S3 database. Azure SQL Databases cannot be created in any random size in the supported range, they must be a specific value. The available values for DTU-based databases are specified here: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-current&tabs=sqlpool#arguments-1

If 50MB was working before, that was some kind of service anomaly. Rejecting 50MB is the correct behavior.

However, I was testing earlier today and I noticed that 250MB is also not working even though it's supposed to be supported. I will check whether this is a documentation issue (and it is really not supposed to be supported) or whether it's a service code issue.

Urs Enzler 41 Reputation points

2020-10-19T05:58:44.06+00:00

Thanks for the link. I'll try that.

Just as a side note, 5000000 is used in the example here: https://learn.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabaseimport?view=azurermps-6.13.0
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2020-10-19T16:47:12.767+00:00

@Urs Enzler

Thanks for sharing the document. Please do check the specifications that you can you use for particular SKU. Also you can use this link https://aka.ms/sitefeedback to provide site feedback on the page above.

Thanks
Navtej S
Urs Enzler 41 Reputation points

2020-10-20T06:37:41.143+00:00

I was able to restore our databases. I had to use one of the supported sizes as listed on the page you linked.
It would be nice, if the error message would state the possible values :-)

Many thanks for your quick help.
Urs
Lorenzo, Eduardo 1 Reputation point

2020-11-24T03:26:08.863+00:00

There was indeed a service change based on this conversation.
Anonymous

2020-12-08T14:02:41.957+00:00

Hi can you share the value you used? I have the same problem.
Urs Enzler 41 Reputation points

2020-12-09T06:59:45.317+00:00

See here for the max size https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-current&tabs=sqlpool#arguments-1
The size there is in GB so I had to multiply it with 1024 * 1024 * 1024 to get bytes.

Answer 2

Jakub Procházka 6

I just run into same problem and find another doc page that is using unsupported value in example script https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-powershell

Share via

Restoring an Azure SQL database with New-AzureRmSqlDatabaseImport results in error "40619: The edition 'Standard' does not support the database data max size '52428800'"

1 additional answer

Your answer