I'm upgrading SQL server to v12 to be able to utilize S3 performance level. Upgrade is running for 28 hours and still not completed. Actually, info in the portal said that it takes up to 24 hours.

Is there any way to determine how much time is needed to complete an upgrade and/or speed up the process? I'm in pretty urgent need of scaling up, but it's locked while server is upgraded.

Hi Ashley,

Just for clarification, you are upgrading a database (logical server) in Azure from V11 to V12?

How long the upgrade takes is depending on the size of your database(s). The larger the database the longer it will take. If it seems the operation is stuck you should file a support ticked through the portal to have the issue being investigated.

Thanks,

Jan

Hi Ashley,

Few other factors that can make the upgrade be faster is the existing connections doing any transactions and deleted databases which you can see on your Azure portal. Cleaning up the deleted databases can make your upgrades be faster.

regards,

Deepa