question

SubhashiniUmapathyMINDTREELIMITED-2421 avatar image
0 Votes"
SubhashiniUmapathyMINDTREELIMITED-2421 asked AnuragSharma-MSFT commented

Error occured while restoring the database in Azure sql server

I’m trying to restore the DB from the exported file and getting below error. Please check and assist as ap. Thanks

202638-image.png


azure-sql-database
image.png (51.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SubhashiniUmapathyMINDTREELIMITED-2421 , please let us know if you need any other details. If any answer helped, you can mark it 'Accept Answer'.

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

Please make sure you are "restoring" (importing) the database with a different name as the source database from where the bacpac was created. Importing database cannot replace existing databases.

In addition, as a workaround, Try using PowerShell instead of the portal.

 New-AzureRmSqlDatabaseImport –ResourceGroupName “sqlgroup” –ServerName “powershellserver” –DatabaseName “mypowershelldatabase” –StorageKeytype “StorageAccessKey” –StorageKey $primarykey -StorageUri $StorageUri –AdministratorLogin $credential.UserName –AdministratorLoginPassword $credential.Password –Edition Basic –ServiceObjectiveName B -DatabaseMaxSizeBytes 50000

Finally, make sure the access tier of the bacpac on Azure Storage is type "Cool".



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.