question

mchallis avatar image
0 Votes"
mchallis asked AlbertoMorillo commented

Backup from deleted DB

I recently copied a sql database and then deleted original broken database - replicating a broken database

It is an S1 package with 20 DTU's at around £28 p/m

I have gone into my deleted original database and attempted to restore the deleted database to a date and time available before when it was broken and working.

However, when going to create the deleted DB at the chosen restore point i get this:

SQL database by Microsoft

Estimated cost per month
325.98 GBP

It is giving me the only option of Gen 5 with 2 vcores??

Many thanks in advance to anyone able to help out.

azure-sql-database
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.

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo commented

Allow the GUI to use that service tier. After the database is restored you can change the service tier of the database to the type you want (DTU-mode, v-corde) and to the service tier you want.

· 4
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.

Thank you for your answer.

This is what i originally hoped i would be able to do but didn't want to click GO without coming here first and you've helped me there.

I also guess i'll be charged between the restore pricing and the changed pricing right, meaning the gap between the change?

Thanks for your help Alberto :)

0 Votes 0 ·

You will be charged per hour for the highest service tier you use. For the service tier you shared with us you will pay like 60 cents per hour. Nothing to worry about.

1 Vote 1 ·

Thank you - marked as accepted answer :)

1 Vote 1 ·
Show more comments
mchallis avatar image
0 Votes"
mchallis answered

127646-pricing-original.png127658-pricing-new.png



attached comparison.

Original DB v Restore pricing


pricing-new.png (34.6 KiB)
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.