Restore .bak into SQL Managed Instance

Question

We have a requirement where a third-party vendor sends us .bak files every day and I have managed to find a way to restore the .bak into SQL managed instance using the Restore command.

I need to know how much it will cost to restore and drop databases in SQL managed instance every day.
I need this as a part of the project plan and cost estimates. I am restoring by executing the Restore script and the size of the .bak file is around 200MB.

Answer 1

As Olaf already stated, there are no additional costs for any activity on the MI.

If you restore that database and keep all those databases daily, your storage might be used to the full, which might create additional costs, but if you just have one database that gets dropped and restored every day... no worries, that won't create any additional costs.

If you are using other services to run the automation, that might create additional costs, too... depending on which service you are using, there might be just xxx runs including in the base fee, and if you use more than that.. you have to pay an additional fee for that automation... but you just asked about Restore/Drop...

Answer 2

the cost of restoration and deletion everyday

Why do you think there is a fee for a restore or any other operations?
You pay for CPU, RAM + storage = size, not for what you do on the SQL Server.